View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Searching for a contact without going through the whole list.

If your data is in a column, you can use the MATCH() function to find the row
the data is on.


=MATCH("james",A:A,0)



--
Gary''s Student - gsnu200753


"vvsmith" wrote:

I have a large contact data base in Excel, and I send out a lot of mailings.
Some get returned back to me, return to sender. Is there a way to look up
those names for deletion without having to go through the whole list of names?

Please help, going blind looking through all those names.
Thank you