Thanks. That gives me a COUNT of ROWS of lots - NOT of "Discrete" lots. For
instance, your Pivot Table gives me 5 lots in Location A - there's only one.
Lot 5.

And, to get fancier, I actually need to separate out those with a "Pass" of
"1" from the rest, but that's a different issue (on the master sheet, it's a
"COUNTIF" deal.)

Open to more thoughts!

"Herbert Seidenberg" wrote:

Try Pivot Table
http://www.freefilehosting.net/download/3adka