Simply Brillant - Thank you, Tom and Barb!

"Tom Ogilvy" wrote:

Put in a dummy column with a formula like

=if(countif(A:A,A2)=3,"Show","No Show")
and dragfill down the column

Assumes the names are in column A.

then use this field for a pagefield on your pivot table and only select show.

--
Regards,
Tom Ogilvy

"DTTODGG" wrote:

I'm thinking you may need some VBA to do the rest of what you want. You may
want to post this in the PROGRAMMING group to see what they say.

"DTTODGG" wrote:

I did sort the top ones, but the pivot table will not let me "delete" the
others.
Help!

"Barb Reinhardt" wrote:

You could sort the count in descending order to get the top ones. Maybe
someone else has a better suggestion.

"DTTODGG" wrote:

Thank-you for the pivot table suggestion.

I have created the pivot table, but there are MANY companies that have less
that 3 occurances. I don't know how to not show them on the pivot table.
Somehow, if the company is listed 3 or more times, I want them, if not, I
don't.

I can see using the pivot table after I have weeded out the little guys - or
find a way to eliminate them on the pivot table.

Thanks again.



"Barb Reinhardt" wrote:

I'd either do this using the countif function or with a pivot table. I
think it would be easier with a pivot table. Check this out and if you have
questions, come back

http://www.cpearson.com/excel/pivots.htm

"DTTODGG" wrote:

Hello-

I have a very large file. In column "G" are company names sorted alpha. But
they can be repeated row after row.

I need to know which companies are listed 3 or more times.

Adam
Adam
Bob
Bob
Bob
Charlie
Doug
Doug
Doug
Doug

So, do I put a count in a new column "H"?
Adam 2
Adam 2
Bob 3
Bob 3
Bob 3
Charlie 1

Then I need a report show if count is greater than or equal to 3:
Bob 3
Doug 4

Is this possible?
Thanks in advance!