View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Detect Presence Formula

I need a formula that will detect the presence of a value in an unsorted
named array.

Column A would be the named array.
Column B would be the value I want to test for.
Column C would be the formula.

So, this is sort of what it would look like. "D" is the only value that
would return a True because it is the only value present in the named array.

D I False
B O False
W D True
T A False
J P False

Anyone know how to do this?