Forum Discussion

jaylaplante's avatar
jaylaplante
Copper Contributor
Dec 30, 2020

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

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!

excel
Formulas and Functions

2 Replies

  • adversi's avatar
    adversi
    Iron Contributor
    Dec 30, 2020

    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

    • jaylaplante's avatar
      jaylaplante
      Copper Contributor
      Dec 30, 2020

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

Resources