Counting cells, based on value

[MagdaLena23]

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!

[azumi]

Y used formula and conditional format to hidden numbers, hope this helps

[kvsrinivasamurthy]

In C2

=$A$2

In C3 then drag down

=IFERROR(IF(ROWS($C$3:$C3)=SUM($C$2:$C2),INDEX($A$2:$A$5,1+COUNT($C$2:$C2)),""),"")

[MagdaLena23]

Thank you so much guys. I'll try it on the spreadsheet with more values and let you know how it goes. Much appreciated!

[MagdaLena23]

I used this formula multiple times now, on many different spreadsheets, adjusting to each set of data. It works magic, again, thank you. I'm trying to understand: what is the "1+ COUNT" meaning.

[JeteMc]

A good way to find out what a formula, or part thereof in this case, is doing is to select a cell containing the formula, say C10, and run the Evaluate Formula feature. If you do you'll see that the COUNT function counts how many numbers are already in column C then 1+ increments that count so that the INDEX function retrieves the next (3rd) number from the range A2:A5
Let us know if you have any questions.

[kvsrinivasamurthy]

If satisfied pl mark the thread solved.