Forum Discussion
Trying to sort by dates entered in 2 different columns
So I have data in 8 different columns. 4 of those columns will have dates in them and as you can see from the image, the dates won't exactly match most of the time. So, I'm trying to get ALL of the d...
As variant
=LET( a, SORT(WRAPROWS(TOCOL(A6:H1000),2)), FILTER(a, CHOOSECOLS(a,1) ) )
Here is an alternative approach using VBA.
Hope this will help you.