Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Highest Value for Each Record
Is there a way to filter for the highest value in a list of records?
For instance if I have the following table: Column X Column Y a 1 a 2 a 3 a 4 a 5 a 6 a 7 a 8 b 1 b 2 b 3 b 4 b 5 c 1 c 2 c 3 c 4 c 5 c 6 c 7 c 8 c 9 c 10 Is there a way for it to give me the highest value from Column Y for each item listed in Column X so that I would end up with the following Column X Column Y a 8 b 5 c 10 It can be a filter, query, or formula, it doesn't matter. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I record new Highest / Lowest numbers as data changes in ce | Excel Discussion (Misc queries) | |||
how do I find 2nd highest MAX in a row | Excel Discussion (Misc queries) | |||
How to find the highest name in an alphabetic list? | Excel Worksheet Functions | |||
Find the highest value on the column | Excel Discussion (Misc queries) | |||
i need a function to find the highest value in a list | Excel Worksheet Functions |