Multiple row has same order nos but need to extract unique order.Please find the below example screenshot

Learning Hub Academy Feedback
,
1

Multiple row has same order nos but need to extract unique order… If row of any particular order no contains the date then it should be considered as unique based on the latest date but if no date was present then it should take the first one. Please anyone provide me the linq. expression for this.Please find the below example screenshot.Image

2

@somnathde2008 Should the rows be Selected based on the latest date value ?

3

@somnathde2008 Check this Workflow :
Check the Input File. Execute the Workflow. It Should Generate the Expected Output in the Same Excel. If it is not the Expected Output. Please explain in a bit more detail.

GroupByAndSum.zip (8.3 KB)