So I have ran into the most strange thing. When I input my data and do a countif on line 24 the first 3 cells count then the rest after that do not. No matter how I modify the data on the lines above it will not count. Anyone see something wrong?
So I have ran into the most strange thing. When I input my data and do a countif on line 24 the first 3 cells count then the rest after that do not. No matter how I modify the data on the lines above it will not count. Anyone see something wrong?
It works for me?
T U V 1Answered: B B 2Answered: B B 3Answered: A B 4Answered: B B 5Answered: B B 6Answered: A B 7Answered: B B 8Answered: B B 9Answered: B B 10Answered: A B 11Answered: B B 12Answered: A B 13Answered: B B 14Answered: A B 15Answered: A B 16Answered: B A 17Answered: A B 18Answered: B A 19Answered: No answer No answer 20Answered: B B 21Answered: A B 22 23a b 24 8 18
Do you have calcs set to manual. perhaps?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The first 3 rows work then after that NADA, Zip, Zilch.
You can see from my post above, that the count is working as it should.
Is that really what your actual file looks like, or just dummy data?
If that was dummy data, check your actual data for leading/trailing spaces, typos etc
It is actual data. I have tried this on 2 different computers with 2 different versions of excel with the same results. Bizarre.
Answered: B B A B D D B A C D C C B C A B D B A D D A B B D
Answered: B B B C E B C D D D C C D A D B C C C C C C C C C
Answered: A B No answer A D No answer No answer No answer No answer No answer No answer B C No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer
Answered: B B A B D D B D C B B C D D B B A A D C D A B C D
Answered: B B B A D B A D C No answer No answer C D No answer B D B No answer C A D B No answer C D
Answered: A B A A E D C A C B D C D C B D A A C C D A C C B
Answered: B B A B C C A A C B A C C No answer A C A A B C C D B C D
Answered: B B A A E C A A C D D C D C B C B A B C D A D C D
Answered: B B B A D C D C C C D C E D B A A B B C D D B B B
Answered: A B B A C C D D C B B C E B B C A C A A C A C A C
Answered: B B A A E A C B D B D C B No answer B No answer A No answer D No answer D No answer C No answer No answer
Answered: A B B A E C A D C B D C E B B B C B B C C B B C B
Answered: B B A A D No answer No answer D No answer No answer No answer No answer No answer No answer B No answer No answer No answer No answer No answer D D No answer No answer B
Answered: A B B A E A D A C B D D B B A C C A B A D B C B B
Answered: A B B A D C C C C B D B D B A B C B A B A D D B B
Answered: B A B D D C D C C B D C No answer B C C B C C C D B A C B
Answered: A B A C E No answer A B C No answer D B E No answer B B No answer No answer B D B B B A B
Answered: B A B A B C D C C A D B D B A C C C B D B B C B C
Answered: No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer
Answered: B B B C C C D C C A D C C B A C B A B A A A A C B
Answered: A B B A B C C No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer
a b a a e c c a d b c b d b a b b b c c d d c b d
8 18 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
I am so baffled. I have changed the formatting to general to text, copied and pasted to notepad and copied it back. Even if I try and change the grade manually it doesn't change the results. I have done this several times before with no problems, and now this....
Hi,
You have Trailing Space in ALL your Column Data From X1:AS21.
Are these values manually entered, or imported...
The data is radio clicked entered then exported to a file. There must be a programming error somewhere.
Ok,
Then until you correct the problem from the source of the data, you can use this for the meantime, in X24, copied to AS24:
=COUNTIF(X1:X21,X23&"*")
I am getting a syntax error with that jtakw
I'm not, are you sure you entered the formula correctly, see attached.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks