Hello

can I PLEASE get some help- I have a list of inventory:

Item qty
apples *formula [=countif(sheet2!a:a,A1) - where A1 is eual
to apples]
oranges * same
Pears * same

in sheet 2

oranges
apples
pears
bananas
kiwi
apples
oranges
etc. etc. (arox 500 items)

i need a formula or a method to "List" (i assume accross several cells) the
items in sheet2 that do not equal or match the inventory items in sheet 1
ie. kiwi and bananas and then count them

Thank you in Advance
--
j.t

One way will show notthere if NOT there.

=IF(ISNA(MATCH(C3,Sheet10!D:D,0)),"notthere","")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"j.t" wrote in message
...
Hello

can I PLEASE get some help- I have a list of inventory:

Item qty
apples *formula [=countif(sheet2!a:a,A1) - where A1 is
eual
to apples]
oranges * same
Pears * same

in sheet 2

oranges
apples
pears
bananas
kiwi
apples
oranges
etc. etc. (arox 500 items)

i need a formula or a method to "List" (i assume accross several cells)
the
items in sheet2 that do not equal or match the inventory items in sheet 1
ie. kiwi and bananas and then count them

Thank you in Advance
--
j.t