Filter a Group by Max Value

[Grahamfeeley]

Hi, hope I can get some help here please.
I wish to filter a worksheet with Max Val for a group
Group is in A column
Values are in I column
Appreciate any help here please
Graham

[karmapala]

Sorry, this is may not help you as I can't understand what you mean about filtering.

Anyway the code below will list on column K
each name in column A with it's maximum value in column i.

Please Login or Register  to view this content.

I wish to filter a worksheet with Max Val for a group

Based on the information of the list in column K, then later on you can filter the data.

The things which is not clear to me :
Did you mean that you want the code to just loop the filter process,
without you even can't have the chance to see the filtered result ?

OR
did you mean the code will loop and stop on each filtered result by giving you a message box ?
Something like this :
The code filtered the max value of Graf1
then show a message box - so you can see Graf1 max value...
after you hit OK in the message box,
the code filter the max value of Graf2
then show a message box - so you can see Graf2 max value...
and so on
.
.
.
until the last group ...
the code filter the max value of 8
then show a message box - so you can see 8 max value...
after you hit OK in the message box,
the code stop.

something like that ?

[Grahamfeeley]

Thank you for your help it is always appreciated
It works as you have done so, however I need to filter on those filtered items, is it possible to add the code to do so ???
Or tekll me how to filter on those selections
Regards
Graham

[Grahamfeeley]

Hi sorry I did not read properly your added text to the request.
I will add the final files and you will understand then I am sure
Sorry for the mix up

[jindon]

Please Login or Register  to view this content.

[bakerman2]

My guess is you want the entire row results.

One way to do it.

Please Login or Register  to view this content.

[karmapala]

Please make sure that there is already sheet Sheet2 which is blank.

Please Login or Register  to view this content.

The result (as seen in your second attachment Sheet1) is put on Sheet2.

[bakerman2]

See my previous post for a slightly enhanced code and example file.

[jindon]

Grahamfeeley,

If you want the result for each row that have max value then no loop needed.

Please Login or Register  to view this content.

[Grahamfeeley]

Thank you both Kampala and Jindon,while I have known Jindon for many years now helping me out
So it is all good for both of you and I appreciat it
Regard
Graham

[alansidman]

An alternative solution is using Power Query.

Please Login or Register  to view this content.

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.