Thank you for reading. I hope you can help me find solution to this problem: I have numbers in column A - A1:3, A2:5, A3:4, etc. I need excel to count the cells below, based on the value and drop the next value down and so on. In other words, I need the result to be: Value 3 is still in cell A1, but A2 & A3 are blank. Value 5 now is in cell A4 and value 4 is in the cell A9. If there would be another value, it would be in cell A13. Please, see attached example to better understand.
I tried some formulas and functions but nothing worked.
Thank you very much!
Bookmarks