Thread: What function will check a row for a series of specific numbers?
View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default
=SUMPRODUCT(--(A1:M1={1;5;7;8}))0

Regards,

Peo Sjoblom

"PuzzledK" wrote:

I need to check a row of numbers, to see if specific numbers (say 1,5,7,8)
are in that row.
What is the easiest way to do this?

Reply With QuoteReply With Quote