|
Count = 3 multiples in column
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! |
Count = 3 multiples in column
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! |
Count = 3 multiples in column
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! |
| All times are GMT +1. The time now is 08:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com