Organising Data from list into table

Hi
I am trying to organise a long list of reference numbers into a table that shows the reference number and then the quantity of that number. I have attached a simplified version of this. I would like to do this using a formula so that when i add another ref number to the bottom of the list it then updates the table so that it shows the new quantity. See below picture for a simplified version of what i would like to do using a formula.

Excel Help.PNG

Some will say to just change the quantity but i am using a bar code scanner and it just adds the ref number to the bottom of the list so that is why i cant just change the quantity. I am not bothered about the numbers being in order on the table.

Thanks for any help

Try this
1. Enter formula in D4 and copy down

Formula:

Please Login or Register  to view this content.

2. Enter formula in E4 and copy down

Formula:

Please Login or Register  to view this content.

Please try at

D4
=IFERROR(INDEX($A$3:$A$99,MATCH(0,INDEX(COUNTIF(D$3:D3,$A$3:$A$99)+($A$3:$A$99=""),),)),"")

E4
=IF(D4="","",COUNTIF(A:A,D4))

Copy both down