Forum Discussion
How to find unique value and display the value based on the earliest date/time criteria
If you use Power Query the easiest way to generate second table is by it.
- reference first query
- sort by Sprint and Time, both ascending
- add Index to fix table in memory
- remove duplicates on sprints
- remove other columns
- load to sheet
Please check attached.
Source : https://www.extendoffice.com/documents/excel/3333-excel-find-earliest-date-based-on-criteria.html
Kutools for Excel’s Advanced Combine Rows feature can help you to get the earliest or latest date of each item in Column A without any formulas.
| https://www.extendoffice.com/product/kutools-for-excel.html : with more than 300 handy Excel add-ins, free to try with no limitation in 60 days. |
https://www.extendoffice.com/download/kutools-for-excel.html Free Trial 60 dayshttps://www.extendoffice.com/order/kutools-for-excel.html PayPal / MyCommerce |
If you have installed Kutools for Excel, please do as follows:
1. If you want to keep the original data, you can copy and paste the data to another range, and then select the pasted range that you want to use.
2. Then click Kutools > Content > Advanced Combine Rows, see screenshot:
3. In the Combine Rows Based on Column dialog box, please click the column name that you want to get the date based on, and then click Primary Key option, see screenshot:
4. Then click the date column that you want to return the latest or earliest date, and select Calculate > Max / Min, ( select Max to get the latest date and Min to return the oldest date), see screenshot:
Website : https://www.gnitcm.net/today-jobs/
Tips: If you check My data has headers, your header within the data range will be ignored automatically, to get the correct date format, please uncheck Use formatted values option.
5. Then click Ok button, the latest or oldest date base on each item has been returned as follows:
Source : https://www.extendoffice.com/documents/excel/3333-excel-find-earliest-date-based-on-criteria.html