new, old, difference

This is most likely a very basic question, since I am a relatively low
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 out


---
Message posted from http://www.ExcelForum.com/

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 " wrote in message
...
This is most likely a very basic question, since I am a relatively low
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 out


---
Message posted from http://www.ExcelForum.com/

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

thanks again


---
Message posted from http://www.ExcelForum.com/