Hello,
I wish to generate an "ascending order no" for (2) columns of data that are not in ascending order based on those columns (the tables are in ascending order based on a different column, "Data Sequence"). Currently I am doing this by temporarily sorting the column in question in ascending order, manually generating the "ascending order no", then returning the tables back to their original order state, which based on the ascending order of a different column, "Data Sequence".
Attached is the file, "List Order", where on Sheet1, I need the "TimeStamp order" and "Distance Order". I have manually inserted the desired results.
Please note that one of the columns in question ("Distance Order") has "999", and this always needs to be "999", and the remaining non-999 values need an "ascending order no".
I desire a formula solution, but a non-control-shift-enter solution, as my co-workers tend to invalidate these array formulas too easily.
Helper columns are OK.
Many thanks in advance!
Bookmarks