May 21 2020 10:25 AM
Hello,
Me again - I am really struggling with this report :(
For each Account name in column B (indirect tab), I need columns A, C, D, E, F and G to lookup the corresponding info where its the MAX definitive end date for that account name.
The lookup should take values from tab 'salesforce contracts 20th May' (currently it points to a pivot but i'm trying to avoid pivots and to instead navigate the raw data directly as much as possible). Here the account names are repeated as they have several contracts each. I want the information in the 'Indirect' tab to correspond to the latest definitive end date.
Thanks so much for your help!
May 21 2020 09:54 PM
SolutionHi, Simply you can sort the column Definitive Ending Date Newest to Oldest and do a vlookup on account name to fetch all details.
May 22 2020 02:57 AM
Apr 30 2021 04:20 PM
Apr 30 2021 10:04 PM
May 01 2021 03:26 AM
May 21 2020 09:54 PM
SolutionHi, Simply you can sort the column Definitive Ending Date Newest to Oldest and do a vlookup on account name to fetch all details.