Dec 30 2020 01:22 PM
Hello - I'm looking for a formula to auto-number a cell based on the sequential order in which the a cell in the same row was filled in another column.
Example:
Column D (sequential order of fill - unrelated to Column E)
D1 D2 D3 D4 D5
3rd 1st 4th 5th 2nd
Column E (numbered based on sequential order of fill in Column D)
E1 E2 E3 E4 E5
3 1 4 5 2
I've explored COUNTA, COUNTIF, and ROW/OFFSET combos to no success. Any support is appreciated!
Dec 30 2020 01:32 PM
There is no formula that tracks the order in which a cell is populated. The best case solution would be to incorporate a macro for worksheet changes -- maybe someone else will be able to help with that
Dec 30 2020 03:12 PM
@adversi I had a feeling I was trying to do something Excel couldn't. Thanks for the macro tip!