Thread: how do I show a value = a value in a range (A1 = any(b1:b35)?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default how do I show a value = a value in a range (A1 = any(b1:b35)?
Hi!

=ISNUMBER(MATCH(A1,B1:B35,0))

Or:

=COUNTIF(B1:B35,A1)0

Biff

"Mike W" <Mike wrote in message
...
how do I show a value = a value in a range (A1 = any(b1:b35)?


Reply With QuoteReply With Quote