See the attached example.. what function can I use to filter out only the latest record (by date)?
See the attached example.. what function can I use to filter out only the latest record (by date)?
How about with a pivot table?
Put a header in A2, A3, and A4
In A4, a new column...
=MAX(IF($A$3:$A$13=A3,$B$3:$B$13)) >> Enter with Ctrl + Shift + Enter
Now create a pivot table and add the first and second column as Rows
HTH
Regards, Jeff
You have a few options. Here are two:
A) Create a PivotTable using Min of Date (format number to show as a date). This will require that you give your data headers (not a single merged cell as in your example).
B) Copy and paste column A into a new column (let's say column D) then remove duplicates on column D (this step can also be done through a formula if you want). Now put this formula in E2:
=MIN(IF(A$2:A$12=D2,B$2:B$12)) Ctrl Shift Enter
See attachment for clarification.
Whoops... I thought that you said earliest dates for some reason.
Just switch MIN to MAX in the formula (or PivotTable if you want to go that route).
Because you've Ex2016 and built-in PowerQuery (Get&Transform) you can try with Grouping by Person and Max for Date column
Change/Add/Remove something in source table then right click on result table and refresh
Last edited by sandy666; 10-12-2017 at 03:04 PM.
Thanks for the rep! I am assuming that one of our responses answered your question?
If so, please mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks