Formula help - Number cell based on the order in which a cell in another column was completed

Copper Contributor

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!

2 Replies

@jaylaplante 

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

@adversi I had a feeling I was trying to do something Excel couldn't. Thanks for the macro tip!