Grouping using two columns of data...

  • Thread starter Thread starter AlexanderG
  • Start date Start date
A

AlexanderG

Morning,

I have two columns of data, large numbers of data, three full sheets.

Column A has account names

Column B has transaction dates

We have multiple transaction dates for the same account names, how do
group whatever the greatest date is for that one account?

What I'm trying to find out is what the last activity date is pe
account. So ideally I would like to see the result as the account nam
listed once with the last activity date of that account.

Any help would be greatly appreciated!

Thanks,

Alexander
 
Back
Top