Forum Discussion
jaylaplante
Dec 30, 2020Copper Contributor
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...
adversi
Dec 30, 2020Iron Contributor
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
Dec 30, 2020Copper Contributor
adversi I had a feeling I was trying to do something Excel couldn't. Thanks for the macro tip!