I would like help in trying sort and export some data from a massive spreadsheet. There is a sample XLSX attached.
1 First step is to group each ID together.
2 Next I want to sort a month (April in the axample file) with the highest figure for each group.
So in ID 101 Dawn would be the highest with 116.
Or in ID 102 Lola would be top.
3 The bit I cannot do is just show the Row for each ID's Highest figure.
4 The final bit I would like to do is export the data, to a new worksheet. This would be for each ID the row which has the highest figure, so 1 row per ID. Again not sure how to do that.
(subsequent edit) If there were 2 people with a joint highest figure then they would both(all) need to be listed at point 3.
(2nd edit ) Glenn that is good in how it shows the highest person but I trying to see the whole row of information for each resulting highest person per ID. I had been soring by ID then Month and removing duplicates - from ID column.
This works except when there are joint highest in any grouped ID as it just show the first named of the two. I have attched Chris2.xlsx and in ID 103 have 2 names with a joint highest number now.
Thanks if you can help on something I have spent a bit of time at not being able to do properly.
Bookmarks