|
| 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
November 12th, 2009, 04:05 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
November 12th, 2009, 04:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
November 12th, 2009, 04:51 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
November 12th, 2009, 05:39 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
