LinkBack URL
About LinkBacks
Morning all,
See attached for a good description of my issue.
Just need to use a countif to count how many times the value from one cell - occurs as part of a string, in another cell.
Thanks in advance, for your help.
Morning all,
See attached for a good description of my issue.
Just need to use a countif to count how many times the value from one cell - occurs as part of a string, in another cell.
Thanks in advance, for your help.
In C3 try:
=SUMPRODUCT(--(ISNUMBER(FIND(TRIM(B3),$F$3:$F$8))))
And copy down.
Edited to add:
This will also work:
=COUNTIF(F3:F8,"*" & B3 & "*")
Although it will initially return 0 in C3, because there's a space at the end of the B3 text which needs to be removed.
Last edited by Andrew-R; 12-21-2012 at 05:28 AM.
In C3 cell
Formula:
Please Login or Register to view this content.
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
use array formula
{=COUNT(--FIND(TRIM(B3);$F$3:$F$8))}
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks