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

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
 
D

Don Guillett

One way will show notthere if NOT there.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to add Multiple rows in same sheet 1
Retrieve Column Header for Specific Data in a Row 3
COUNTIF formula? 1
How can you replace specific characters in a string ? 2
Multi column sumproduct 3
Stripe out duplicate data 5
Index/match across multiple columns? 19
Another Running Totals Problem 9

Top