Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index Formula
I need some help and haven't had luck searching for it on here. I have a
large spreadsheet that has location info in column A. The rest of the columns contain the pricing for each location by supplier. My table looks like this: Sup 1 Sup 2 Sup 3 PIT 5.50 6.00 6.00 LAX 5.50 5.50 4.50 ORD 6.00 5.25 5.50 In Column E, I'd like the max value, and in Column F, the Supplier Name(s) with the max value for each location. I'm good with Column E (=MAX(B2:D2)), and getting "6", but I'm stuck on Column F. I found this formula: =INDEX($B$1:$D$1,MATCH(MAX($B2:$D2),$B2:$D2,0)), but it's only returning "Sup 2" where I'd like to see both Sup 2 & Sup 3. I have no problems listing each supplier in a different column, but when I drag it over to Column G, I still only get Sup 2. All help is greatly appreciated!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Help (IF) ... INDEX | Excel Worksheet Functions | |||
If or index formula help | Excel Worksheet Functions | |||
INDEX and MATCH in one formula... | Excel Worksheet Functions | |||
Index formula help | Excel Discussion (Misc queries) | |||
Sum and Index formula? | Excel Discussion (Misc queries) |