How can I get the frequency of occurrence of a string of text in Excel using a formula?

Question

The strings I'd be searching all occur in the same column.

Answer 1

i would guess you would use a countif() formula for that.

could you please provide a good easy 5 line (cells A1 to A5) sample of the type of text?

otherwise just try something like this

=countif(a1:a5,"YourText")

good luck

edit-

then the countif formula will work

make a quick sample test sheet:

lets say your full districts are in column A assume maybe A1 to A9000 and you want a count

then in column B1 to B435 you can copy your list of individual districts

then in C1 use this formula

=COUNTIF(A$1:A$9000,B1)

then copy&paste the formula down to C435

and you should have a count by district right next to the district name.

then you can apply this to your real sheet.

or if you want to make a search box, you dont need to go all down the B and C column, you can just use B1 as a search box.  if you change B1, the count will change.

how does either of those work for you?

edit-

you are welcome

oops- unlike Congress...my original formula forgot the $ signs. (that locked in the range but you already figured that out)

Answer 2

Let's say you want to find out how many unique values exist in a range that contains duplicate values. For example, if a column contains:

The values 5, 6, 7, and 6, then the result is three unique values—5 , 6 and 7.

The values "Buchanan", "Dodsworth", "Dodsworth", "Dodsworth", then the result is two unique values—"Buchanan" and "Dodsworth".

There are several ways to count unique values among duplicates.

use the article below

post details please , so we know if anything has worked!