Forum Discussion
DaButcher
Nov 10, 2024Copper Contributor
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...
Lorenzo
Nov 10, 2024Silver Contributor
Provided you run Excel 365/Web (you didn't mentioned so assumed):
in I6:
=SORT( WRAPROWS( TOCOL( A6:H11, 1 ), 2 ), 1 )