| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to print the column # where the max row value is located?
Hello,
I have a row with 100 numbers in it. This row starts in column C and ends in column CX. I am printing the Maximum number in this row in column B. How can I print the number of a column that contains this maximum. In other words, if the maximum occurs in column D, I would like to print 2 in column A. Thank you very much! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
| Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Dynamic Print Range Help | Excel Worksheet Functions | |||
| Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Threaded Mode
