Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm not sure how to accomplish this and thought someone may be able to give
me some ideas. Here's an example of how my data is laid out. Row 1 Chevy Ford Dodge Row 2 4 5 3 Row 3 5 3 4 I would like to enter a formula that would look for the maximum value in each row and return the corresponding value in the same column, from row 1. In the example the formula looking in row 2, would return "Ford". In row 3 the result would be "Chevy". I've been mulling over this but can't figure out how to make this work. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to find replace text or symbol with carriage return | New Users to Excel | |||
find the largest number in column | Excel Discussion (Misc queries) | |||
how do i find out what is uncommon in column list A1: A10 and B1:. | Excel Discussion (Misc queries) | |||
Find if value in column A exists in Column B | Excel Worksheet Functions | |||
Return non-zero cells in column | Excel Worksheet Functions |