countif, but only using partial cell contents in the reference array

J

jaredh

while it doesn't apear to be exact, i extracted the part that was givin
the error in Excel, and the cell references have been updated in it t
reflect the actual, not the simple i started with...

but much thanks,

jare
 
M

Max

To workaround the #VALUE! errors
if there are cells within the source range A1:A100
which may not contain any "{",
think we could try this ..

Use a helper column, say col B ..

Put in B1: =MID(A1,FIND("{",A1,1)+1,8)
Copy down to B100

Then put in C1:
=COUNTIF(B1:B100,MID(A1000,FIND("{",A1000,1)+1,8))

Perhaps others could offer you alternative insights
which does away with the helper column ..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countif, but only using partial cell contents in the reference array 1
countif, but only using partial cell contents in the reference array 2
countif, but only using partial cell contents in the reference array 1
countif, but only using partial cell contents in the reference array 1
Appropriate use of cell reference when creating macros 3
CountIf previous cell formula 0
How do I delete only the content of cells that are NOT protected? 1
Adding a cell reference to an if then function 4

Top