| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there an Excel formula to show the highest letter in a row?
I am trying to create a formula so that i can have one column which displays
the highest number or letter in any given row. eg 1 - 2 - - 3 - - A B C - - 1 - - - 2 etc. Some cells are left blank (marked by dashes above). I would like a column which displays the highest ranking (so 3 for the first row, C for the second row and 2 for the third row) and automatically updates when new columns are added. Anyone know if this can be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there an Excel formula to show the highest letter in a row? | Excel Discussion (Misc queries) | |||
| Is there an Excel formula to show the highest letter in a row? | Excel Discussion (Misc queries) | |||
| How do I get a graph to show the highest value at the bottom | Charts and Charting in Excel | |||
| Excel Formula - to calculate highest number from a set of numbers | Excel Worksheet Functions | |||
| Can I show server name instead of drive letter? | Excel Discussion (Misc queries) | |||
Threaded Mode
