Log In
Register
Home
September 9, 2020
Offline
Hi,
I have some initial data in an ASIS tab (in reality I have other columns that I have deleted for better readability). Some of these data are duplicates if I only take into account the columns: Date - H - M - TEL_CALLER - TEL_CALLED - DURATION - ANSWER.
Is it possible with Power Query to keep a single unique value corresponding to the earliest hour of the day?
In the ASIS sheet, I put the cell in red in the J column for those that need to be deleted. In the TOBE sheet, I put the result I am trying to obtain.
Thank you very much for the suggestions for a solution.
BR,
Lionel
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Lionel,
Steps to achieve that:
1. Sort datetime column Descending.
2. Edit this step in formula bar, wrap the existing code with Table.Buffer(yourstepformula)
3. Select all the columns that combined creates a unique key and from Home tab, Remove Rows-Remove Duplicates
1 Guest(s)
