I need a formula to count how many times a specific text string occurs in a column of data. However the text string will not always be the same it will be based on the text in cell E2. I tried using a countif and search but it didn't come out right.
I need a formula to count how many times a specific text string occurs in a column of data. However the text string will not always be the same it will be based on the text in cell E2. I tried using a countif and search but it didn't come out right.
If your data is in column A
Formula:Please Login or Register to view this content.
Shelton A.
If Helpful, Add Reputaion!
What do you mean by "based on the value in E2??
What's in E2 and how can the strings vary from what's in E2? Is the content of E2 always at the start, at the end, or separated by come characteristic characters?
Better still, can you post a spreadsheet contsining some examples?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Example.xlsx
I put the counts in manually.
Try
=COUNTIF(A$1:A$10,D1&"*")
Okay you need a wild card:
Formula:Please Login or Register to view this content.
It gives me an issue with the " marks
This seems to work thank you.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks