J
JG
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.
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.