View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Javier Diaz[_2_] Javier Diaz[_2_] is offline
external usenet poster
 
Posts: 48
Default Return Unquie Values

So guys, heres another one

Say in CElls A2:A10 I have values like so;

food
food
test
trial
trial
test

And in B2:B10 I have qtys. I want a total with no filter or pivot that
would return the unique entries into A12 like so

Food
Rest
Trial
Test

Thats about it, I'll take care of the sumif formula for the qy based on this
one thing that I reallly need. Pleaseeeeeeeeeeeee.