Hi everyone,
I have the following formula:
=COUNTIFS('Answer Data Month 1'!$BC$2:$BC$15000,LEFT($N9,255)&"*",'Answer Data Month 1'!$AG$2:$AG$15000,G$8,'Answer Data Month 1'!$BD$2:$BD$15000,"Wrong")
N9 has a long text string which is derived from a data sheet using vlookup.
G8 is a single word
There is approximate 30 possible text strings (N9 - N40) with varying content. I'm finding that the expected results are lower than the actual results and I am certain the expected results are correct. Am i correct in assuming that the text string is what's causing me the difficulties? The strings are almost certainly over 255 characters incluidng the vlookup formula. Any ideas how I could search for long text strings more reliabilty?
Thanks!!
Bookmarks