Output latest date only into Excel

[jenner85]

Hi - I would like to output only the latest date (data is updated every day with previous date and is cumulative). How would I do this?

Input:

Date	TPC	CPC	BAL
9/1/2020	ALL	ALL	1191157
9/2/2020	MC	AAA	0
9/2/2020	MC	ALA	0
9/3/2020	MC	BRW	40500
9/4/2020	MC	BST	0
9/4/2020	MC	BUS	0
9/6/2020	MC	CAQ	0
9/8/2020	MC	CCR	0
9/8/2020	MC	HDV	0
9/8/2020	MC	IT2	0

Output:

Date	TPC	CPC	BAL
9/8/2020	MC	CCR	0
9/8/2020	MC	HDV	0
9/8/2020	MC	IT2	0

Thanks!

[atcodedog05 · Accepted solution]

Hi @jenner85 ,

Here is a workflow for the task.

Input : Table given by you

Output : 

Workflow

Hope this helps : )

If this post helps you please mark it as solution. And give a like if you dont mind : )

[atcodedog05]

Happy to help : ) @jenner85 

Cheers and Happy Analyzing 😀