If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell reference
On the below formula I would like to count if the data in A6 is contained in
A7 where A7 may have more data. =COUNTIFS(A6,"=" & A7) Specifically, A6 may be CE where A7 is CECFCG. I'm not sure what to put in place of "=" to pull a wildcard type result of CE* |
#2
|
|||
|
|||
Cell reference
Maybe........
=ISNUMBER(SEARCH(A6,A7)) Vaya con Dios, Chuck, CABGx3 "sc" wrote: On the below formula I would like to count if the data in A6 is contained in A7 where A7 may have more data. =COUNTIFS(A6,"=" & A7) Specifically, A6 may be CE where A7 is CECFCG. I'm not sure what to put in place of "=" to pull a wildcard type result of CE* |
#3
|
|||
|
|||
Cell reference
You are close
'use wildcard =COUNTIF(A7,"*" & A6 & "*") 'combined with IF() function =IF(COUNTIF(A7,"*" & A6 & "*"),"Yes","no") If this post helps click Yes --------------- Jacob Skaria "sc" wrote: On the below formula I would like to count if the data in A6 is contained in A7 where A7 may have more data. =COUNTIFS(A6,"=" & A7) Specifically, A6 may be CE where A7 is CECFCG. I'm not sure what to put in place of "=" to pull a wildcard type result of CE* |
#4
|
|||
|
|||
Cell reference
Worked great, thanks. I really only needed the wild card after the entry so
=COUNTIF(A7,A6 & "*") is what I end up with. Didn't really understand the cell reference format until now. "Jacob Skaria" wrote: You are close 'use wildcard =COUNTIF(A7,"*" & A6 & "*") 'combined with IF() function =IF(COUNTIF(A7,"*" & A6 & "*"),"Yes","no") If this post helps click Yes --------------- Jacob Skaria "sc" wrote: On the below formula I would like to count if the data in A6 is contained in A7 where A7 may have more data. =COUNTIFS(A6,"=" & A7) Specifically, A6 may be CE where A7 is CECFCG. I'm not sure what to put in place of "=" to pull a wildcard type result of CE* |
Thread Tools | |
Display Modes | |
|
|