****DAMMMMN I CANT DO IT****

  • Thread starter Thread starter j.t
  • Start date Start date
J

j.t

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
 
One way will show notthere if NOT there.

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