|As AlteK says, we'd need more information about your data and how it looks to give you a more specific answer.|
However, here's another suggestion that might work.
Let's say your data is in A1:A20, with no blank cells.
Try this formula:
If you want it make it a little fancier, and perhaps a little more automatic, create a Dynamic Mamed Range by using this formula in the "Refers To" field:
A Dynamic Range Name will change it's length depending on how many rows of data are in the column.
(You can also just use a regular named range by creating one based on the actual data in the column at any given time. You just have to make sure that there are no blank cells in the range or the following formula won't work.)
Let's say you use the name "Container_Count"
Now use this formula in a cell:
This would allow you paste each new list of containers into Column A and update the count.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.