Create new list matching three categories from a list

[richmcgill]

I need a formula to pull out where the account number, account type and last updated all match.

I tried a pivot table but I am working with 10's of thousands of these. Below is an overly simplistic example.

The common element is the Account Number.
If the account number, Account Type and Last Updated all match I need a new list of only the unique items for all three fields.
Meaning if there are 20 matches I only need one representation in the new list.

This is the scenario
Account Number	Account Type	Last Updated
123456	Travel	1/1/2022
123456	Office	2/1/2021
123456	Travel	1/1/2022
Need this
Account Number	Account Type	Last Updated
123456	Travel	1/1/2022

 

[richmcgill]

I need a formula to pull out where the account number, account type and last updated all match.

I tried a pivot table but I am working with 10's of thousands of these. Below is an overly simplistic example.

The common element is the Account Number.
If the account number, Account Type and Last Updated all match I need a new list of only the unique items for all three fields.
Meaning if there are 20 matches I only need one representation in the new list.

This is the scenario
Account Number	Account Type	Last Updated
123456	Travel	1/1/2022
123456	Office	2/1/2021
123456	Travel	1/1/2022
Need this
Account Number	Account Type	Last Updated
123456	Travel	1/1/2022

Found a solution. No longer need help.

 

[smozgur]

Good to hear you found the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.