Counting the number of entries by lotid

i used a technique from an earlier post that someone gave me and it works as well. see enclosed file.

One question i did have is how to get the unique list of lotids. What i did was use the advanced filter option to create a unique list. Is this the best most efficient way? This way is "manual".....is there a more "automatic method". If not thats ok.