Counting Duplicates

[kteicher]

Hello:

I have a spreadsheet of about 20,000 rows. One of the columns has the email address of the purchaser of the item in another of the column.

I would like to be able to add a column or have some way of totalling the number of times the email address appears. The ultimate goal being able to say, hmmm, [email protected] has purchased 123 (or whatever) items.

Can someone provide me with an easy way to accomplish this?

Thanks,

Keith

[Dbase Beginner]

Hi,

1. Select the data range in your excel sheet
2. Go to your toolbar - View - check mark Status bar
3. Go to your toolbar - Data - Filter - select autofilter
4. Select now the specific e-mail address
5. Go with your cursor to the right buttom of your screen
6. Switch by right-clicking to - Count
7. Select now all the entries in a column
8. On the buttom you can now read the number of lines you have for this person

[kteicher]

Thanks, that is helpful.

However, I would like to be able to see how many lines exist for each email address in the spreadsheet. So, is there a way to have a formula in an extra column that would count the # of times that an email address appears and display that?

thx,

keith

[BenjieLop]

Hello:

I have a spreadsheet of about 20,000 rows. One of the columns has the email address of the purchaser of the item in another of the column.

I would like to be able to add a column or have some way of totalling the number of times the email address appears. The ultimate goal being able to say, hmmm, [email protected] has purchased 123 (or whatever) items.

Can someone provide me with an easy way to accomplish this?

Thanks,

Keith

ASSUME:

Column A contains the email address of the purchasers;
Column B contains the quantity of items purchased by the corresponding email address


Your formula to determine the purchased items per email address is

=sumif(A:A,"email_address",B:B)

Hope this helps.

[kteicher]

Thanks,

In re-reading my original message I see that I didn't explain things very well.

Here are some more details.

The spreadsheet has 20K lines.

The columns are:

Column A - The product# bought
Column B - The email address of the person who bought that item.

What I am trying to figure out for EVERY email address is how many times in this spreadsheet this email address appears.

Therefore, the same email address will appear multiple times in Column B, I need to know how many times for each.

I hope that helps! And thank you all for your assistance.

Keith