Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH?
I have 10 columns/1 row that have different numbers. I want the 11th column
to match for a specific number if found. Here's an example with expected result 1 2 3 4 X a c x e 1 t a e k 0 x b i l 1 X=result Can someone help me with the formula? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MATCH?
Probably the simplest formula would be
=COUNTIF(A2:D2,"x") of course, change range to reflect your 10 columns. Note: the number would change if there were more "x"s in the row. If that matters, you would probably want to include an IF test to change it to 1. -- Kevin Vaughn "Annette" wrote: I have 10 columns/1 row that have different numbers. I want the 11th column to match for a specific number if found. Here's an example with expected result 1 2 3 4 X a c x e 1 t a e k 0 x b i l 1 X=result Can someone help me with the formula? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Index | Excel Worksheet Functions | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |