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...
Provided you run Excel 365/Web (you didn't mentioned so assumed):
in I6:
=SORT( WRAPROWS( TOCOL( A6:H11, 1 ), 2 ), 1 )