Forum Discussion

2019's avatar
2019
Helper II
5 years ago
Solved

Extract Recent Date With It's Corresponded Row

I have tried to search in google and in this community to find a solution for this, unfortunately no luck. I have two tables as per the attachements in links below:   Data Source Excelsheet File  ...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    2019 

     

    After Grouping as you showed, expand the "Rest of Column".

     

    add a custom column where you type 

    [Rig Spud] = [Max Date]

    now filter only True from this column then delete unnecessary columns 

     

     

     

Fowmy's avatar
Fowmy
Super User
5 years ago

2019 

Click on the filter of the "Rig Spud" column and choose "Is Latest" under the date filter as shown in the example below.