Hi:

I receive spreadsheets each quarter that identify customers who pay
invoices late. Every quarter, I receive a new worksheet. I have
copied about 16 worksheets (4 years total) into one master worksheet.
What I am interested in doing is asking Excel to show me customers who
appear over a certain number of times, say 4 or more out of the 16
worksheets. (I.e., there are 4 or more rows within the worksheet that
have the identical entry in the field in question) The field in
question could be either a customer number, which is 5 digit number
that could be treated as text or a number, or I could use the mailing
address field, or last name field, etc.. Regardless, is there a way I
can ask excel to look at all records/rows, identify which field has 4
or more identical entries, and then display those records. The max
possible would 16 occurances, if they were late every quarter. Let me
know if I am not being clear enough in my request.

Thank you.