Filtering macro, count number of rows and include count in last column.

I have a table with 6 columns, columns A to E are populated with data while the last column F is to be used by the macro I would like to implement.

Basically column A contains a series of numbers, for example range A2 to A9 contains a single number 84260961, I would need a macro to write numbers 1 to 7 in range F2 to F8. Then do the same for the next unique number in column A.

I assume filtering would be required on column A to only display the first value, then count the number of rows displayed, and finally write the 'filtered' row number in the matching cell of column F.

Not sure if this makes sense, therefore I have attached a screenshot of what I would like to achieve.

Filtering Macro.png

Any help would greatly be appreciated.

Thanks,
Ant

TMS, Mike,

Thank you very much, that's perfect!

Ant