Forum Discussion
Extracting data in the new sheet
the attached excel sheet contain 3 columns i want to extract the rows for every (customer no) with the oldest dates for instance for customer no: 345467 i need 2 21/04/2018 345467 3 2...
Hi,
That could be done with Power Query (add-in for 2010, 2013, built-in in 2016 as Get&Transform)
- first query loads all receipts
-duplicate it in second query, sort by customer and date and remove duplicates keeping only newest receipts for each customer
- left anti join first query with second one, land the result into any place in workbook
Please see attached
Nice approach