ExcelBanter - What function will check a row for a series of specific numbers?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - What function will check a row for a series of specific numbers? (https://www.excelbanter.com/excel-discussion-misc-queries/25738-what-function-will-check-row-series-specific-numbers.html)

PuzzledK

What function will check a row for a series of specific numbers?

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?

Peo Sjoblom

=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?

All times are GMT +1. The time now is 07:08 PM.