new, old, difference

[chinonyc]

This is most likely a very basic question, since I am a relatively lo
level excel user.
Three columns:

New Old Difference
a a b
b c d
c f e
d g
e
f
g

how do I find the difference? sort? filter?

We are talking about hundreds of products listed
in different spreadsheets

thanks for any help
I hope it was clear enough..
I hope you guys can help a newbie ou

 

[Anne Troy]

The *difference* would generally be a number, no? So what do you mean, the
difference? You want to subtract B2 from A2?

=B2-A2 should be typed into C2
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Com.Piersontech@Dreamboat
(Reverse it!)
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

 

[chinonyc]

Thanks dreamboat for the reply,
what I am trying to do it consolidate several worksheets of products i
product listings, i need to compare each worksheet
to see whichproducts are missing. hence the resulting worksheet i nee
created are the products that are not on each one.

thanks agai