It's a little quiz that I've set up and I want whatever is in column D on sheet 2 to be compared to whats in column C on sheet 2.
I've got something together but it's not working correctly. Can someone help please?
It's a little quiz that I've set up and I want whatever is in column D on sheet 2 to be compared to whats in column C on sheet 2.
I've got something together but it's not working correctly. Can someone help please?
There is some difficulties to open the file when downloaded.
Can you upload again your file.
Can you give more details where the comparison to be done.
- Battle without fear gives no glory - Just try
I was unable to open the file for editing - it froze Excel on my PC. I will not try again, I am afraid.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
It's let me open it now that I'm at home on Excel 2016 with no problem at all. I was also able to run it on Excel 2003 and 2010.
Try this:
OK it is better
when you asked for
"whatever is in column D on sheet 2 to be compared to whats in column C on sheet 2."
how would you like the result to be shown ...cells painted in red, amount of bad results displayed ...?
To be honest, I'd like to have the text that doesn't match in Column D to be displayed in red.
What about a conditional format with formula like for D3
=ISERROR(MATCH(D3,C:C,0))
How could I get it to pick out any words that didn't match what was in column c? I mean specific words?
So if the set answer was "My name is Groot." and they answered "My name is Froot." I would like it to just highlight the word(s) that is/are wrong.
Hou la la, not an easy stuff.
Is needed to search for the answer the closiest to the operator answer and then do a comparison word by word ...!
It is a huge project by it self
Hmm, what would be the way of doing it? I'm just asking because it would be perfect for this sheet really.
If the "operator answer" is some free text, I don't see some possibilities, there is too many variations.
What if I had some keywords that I wanted it to pick up? So if I had another column with some keywords, that'd check the column with their answer, and give me a result. That should be quite simple, right?
It may easier, can you show example to see how to do
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks