Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Ron Rosenfeld wrote...
.... Assuming the leftmost column has priority if there are multiple X's, and assuming the contents of the cell is only an X (and not, for example, eXcite), then: K7: =CHOOSE(MATCH("X",F7:F7:J7,0),5,4,3,2,1) Yeah, but it's effectively hardcoded. insert columns between F and J and put the leftmost X in the 6th column. If hardcoding, zero return value for no X in the range, and array formulas were OK, =MAX(IF(F7:J7="X",{5,4,3,2,1})) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert text numbers to numbers | Excel Worksheet Functions | |||
convert numbers to text | Excel Discussion (Misc queries) | |||
numbers to text function | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions |