Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I know this is really easy in Access, but unfortunately I have to work on
Excel... I need to do a query that will search for the maximum value and give me the type. Here's the example: A B 1 Categories Results 2 Type 1 10 4 Type 2 30 5 Type 3 20 In this case, the maximum value for this array is 30. I want my query to find the 30 and give me "Type 2" as the result. I hope that this can be done with built-in formulas, rather than adding a v-basic macro... Thank you! Pablo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to colntrol location of category X axis labels on a bar chart? | Charts and Charting in Excel | |||
i can not find user definded on the function category | Excel Discussion (Misc queries) | |||
Finding Location of Maximum Value in 2D Array | Excel Discussion (Misc queries) | |||
Finding Location of Maximum Value in 2D Array | New Users to Excel | |||
Finding Location of Maximum Value in 2D Array | Excel Worksheet Functions |