This will no doubt sound like a ridiculously simple problem to anyone who understands how to write Visual Basic codes for Excel, but I don't know how to do that. I know just enough about Excel to be dangerous, in that I'm aware it can do some pretty useful stuff that should theoretically save me bunches of time but it will take me hours to find out how. Naturally I tried searching on-line, but usually what I want to do is clearly remedial level Excel and there are no internet Excel guides written in crayon unfortunately.
Today I really wanted Excel to compare two sets of data and simply tell me where there were any discrepancies. It took me freaking forever to work out how to get it to do that, and my solution is as simple as it could possibly be, so I'm prepared to bet that what I ended up with could be much more sophisticated, but it will do.
The code that I eventually got (with the aid of the Excel function wizard) was:
=IF(A1=B1,"Woot!","Boo!")
It's 25 characters, more or less, and I'm making a note of it here so I don't have to spend hours trying to find it again. What it does is look at cell A1 and compares it to cell B1; if they are equal it writes Woot! in cell C1; if they are not equal it writes Boo! (that's what this one does, my one at work checks for room numbers and course titles, etc, so it might say "Room?" instead of "Boo!")
Really quite satisfying, and all the more so because Doc C looked at it too and couldn't get it to work. It almost makes him beating my Little Big Planet high scores, as I am writing this, not sting quite so much.
Recent Comments