| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
=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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| function to check numeric value | Excel Worksheet Functions | |||
| Excel should have a function to verify the check digit on UPC num. | Excel Discussion (Misc queries) | |||
| Why is it important to check the range placed in the SUM function. | Excel Worksheet Functions | |||
Linear Mode
