find and extract row based on column max value

[felipepanza]

My goal is to extract all rows that have the latest period in column D (Period).

Column D show period like year.month (201307)

I know I can use filter, but I want to try another way so I can record the macro that I can use every month.

Because if I use filter and choose the latest period, then I will not be able to use the macro next month, that is 201308.

I tried to upload a file to the file upload manager did not find my computer.
Thank you

[Jul Stev]

Hi, Are you familiar with advance filter?

If yes then u can try to record the advance filter , so next time u only need to change the value in the criteria and run the macro..

[felipepanza]

Yes I use advanced filter all the time.

But if I have to change the criteria everytime the point of using macro is gone.

Now I have to use advanced filter, copy the resultat and then proceed with macro I have recorded.

[L-Drr]

Your notation of YearMonth makes it possible to search for the maximum value, which corresponds to the latest date. So use the MAX formula and then the LOOKUP formula to extract the rows with that value.

[TheCman81]

Is it something like this you are after?

Input your period in E1

Period extract.xlsx

[ragulduy]

Please Login or Register  to view this content.