Count formula after a sheet is auto updated.

[hammer2]

Hi Folks

Greetings from a bush fires smoke filled valley

But to business:

The attached sheet is auto updated from another program.
Each update fills new info into row 2 so all other updates are pushed down one.
I want the Cells in Col G to count the updates as shown ie Cell G2 will always have the highest number.

Row 2 will be blank before the first update so therefore the first update will be number 1 in G2

Hope that makes sense.

Cheers
Hammer

[:) Sixthsense :)]

In G2 Cell

=IF(A2<>"",SUM(1,G1),"")

Drag it down…

[hammer2]

Thanks Sixthsense but I actually need it to work in reverse so to speak.

Row 2 will always receive the new data by pushing previous updates down a row.

So if there have been 3 updates G2 will be reading "3", G3 will be "2" etc

Cheers

[:) Sixthsense :)]

In H1 Cell
=COUNTA(A:A)+1

In G2 Cell
=IF(ROW()<$H$1,$H$1-ROW(),"")

Drag it down…

[hammer2]

Hi Sixthsense
That works thank you very much!
Hammer

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback