View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joshuabrown97 joshuabrown97 is offline
external usenet poster
 
Posts: 4
Default excell search function

I have a set of values and want to create a list of unique values from that
list for a summary.
Ex. List = 1,2,3,2,3
I need column A to return the 1,2,3 because they are unique values. Then i
use column B for CountIF using Column A as a reference. I can get the
CountIF function correct, but i do not know how to search my list and return
the references to Column A.