Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to collect data from a darts team and these values reflect
the number of points won in a team game (ranging from 0 - 3). This will probably be simple for the experts here, so I'll let fly: I have a table with six names across the top. In the rows below there will always be two cells that have number values ranging from 0 - 3 while the rest will be blank. Those two numbers however, will always be the same. I am trying to write a formula that will determine which columns have values and return a single letter value (first initial) for each name. Since all the names are different that is not an issue. ex: Rodney Welles Scott Mina Barry Lorne DBL -01 1 1 DBL -Cr 3 3 The intended results for the first row would be "WS" and "RM" for the second row. I have been trying IF() constructions but am now stymied. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
Conditional Format Not Working | Excel Discussion (Misc queries) | |||
Conditional formula - language needed | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |