Counting Text in a Column

Status
Not open for further replies.
S

scomar411

New Member
Joined
Jul 13, 2007
Messages
11
How can I total the number of cities showing, in separate column, in a column of 7,100 entries? Example below...

Anchorage
Anchorage
Seatle
Seatle
Dallas
New York
New York
New York

etc...

Many thanks
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

A
  • Question
google sheets - manual entries to cells in column A become the list source for autocomplete in column B
Replies
0
Views
126
aonefun
A
I
  • Question
SQL query in BO
Replies
0
Views
220
iluvsafc
I
K
  • Question
SharePoint miscalculates the week number.
Replies
2
Views
325
keyra
K
J
  • Question
Google Sheet - Count Drop Downs, Total Columns, Check, Array - Errors
Replies
0
Views
194
jennifer7i884
J
K
  • Question
a formula for counting a specific word in one cell "Trial" and converting it to a percentage
Replies
5
Views
351
khollibygolli
K

Forum statistics

Threads
1,216,175
Messages
6,129,312
Members
449,500
Latest member
Jacky Son

Share this page

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
Back
Top