Forum Discussion
Copy data from one table to another ordered by date
Hi everyone, Hope you are well. I get by in excel and able to use the most formulas for my needs. However this one has stumped me. I have a table with employee details within. I basically...
Thanks - this is the type of formula I was looking for - however it actually only delivers the same as my own formula above. Your example does not filter the table by date the employee left. I would have to use a macro to autofilter or manually sort. Am I missing something?
If with sorting that could be
=LET(
range, A1:INDEX(B:B,COUNTA(A:A)),
allLeaveDates, B1:INDEX(B:B,COUNTA(A:A)),
rangeWithLeaves, FILTER(range,allLeaveDates<>""),
dates, INDEX(rangeWithLeaves,0,2),
sortedRange, SORTBY(rangeWithLeaves,dates,-1),
sortedRange)