Dec 08 2021 08:45 PM
I have an excel where column E and F are sorted each column, however, I want column E & F to be sorted simultaneously so that both column dates are in sequential ascending order. I have attached one excel with the current issue and the proposed result
Dec 08 2021 09:18 PM
@Shano1989 Not in one go. That's just not how it works. but you can add a column summing the dates in E and F. This creates one column of dates which you can then sort from Oldest to Newest.
If both E and F can hold dates and you want the latest of the two to determine the sort order us a formula like =MAX(E4,F4) or =MIN(E4,F4) in case it should be the earliest of the two.
Dec 08 2021 09:21 PM