Thread: Displaying what column a piece of data is in
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darren Bartrup[_2_] Darren Bartrup[_2_] is offline
external usenet poster
  
Posts: 36
Default Displaying what column a piece of data is in
If A1:D1 contains Darren, Dave, Sid & Bill then the formula:

=MATCH("Sid",1:1,FALSE) will return (column) 3.


Reply With QuoteReply With Quote