How to set a forumla to count letters in a row once.

madforgolf

Board Regular
Joined
Oct 20, 2006
Messages
177
Office Version
  1. 365
  2. 2016
Hi,

I have a list of letters in Column A that include about 3000 letters. they are 6 digits long and have a combo of letters and numbers but some are only letters.
These letters differ each month and not all appear each month the letters differ daily.
So whats the best why other than filter each letter and deleting all but one to to find how many total letters was used each month. that's time consuming atm.
There were 162 different letters used in total, this is what im looking for the total different letters used. Could a macro be made to do this.

Thanks in advance
Marty
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

madforgolf

Board Regular
Joined
Oct 20, 2006
Messages
177
Office Version
  1. 365
  2. 2016
Thanks Domenic for the reply.

The examples are count whats repeated and how mant times is occurs.
Im looking for the total number of different letters used, not how many of each is used.

Thanks anyway.
 

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,406
For clarity, can you please post a small sample of the data, along with the expected results?
 

madforgolf

Board Regular
Joined
Oct 20, 2006
Messages
177
Office Version
  1. 365
  2. 2016
Thanks for reply but i forgot about the advanced filter and unique sort. This has now done what i wanted. Looking for a long winded answer when it was already there in a simple form.

Domenic,
I will be using the page you sent to colllated the totals along side the letters.

Thanks

Marty
 

Watch MrExcel Video

Forum statistics

Threads
1,122,463
Messages
5,596,283
Members
414,051
Latest member
tabecker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top