Office Wide Excel Skills Test

[Greg Truby]

^¿¿Intermediate_?? Am I overlooking some very simple strategy on your #10. I didn't work out a formula for it, but my first inclination is some unholy mix of Substitute in an array formula that uses Char(Indirect(Rows(65:91))) to do this. Not what I would call intermediate. Is there some very easy strategy that I've not considered? Or do you consider knowledge of the Indirect(Rows()) trick in array formulae to be "intermediate" and if so, what (dare I ask) would you consider "advanced"?

 

[Zack Barresse]

LOL! Okay, some may borderline Advanced. Especially w/o VBA, as I would turn to first with RegExp most likely. Would it be safer to say that list was Intermediate-Advanced??

 

[Greg Truby]

Ah, but Mssr. Zack, in the third post, todd said "without involving VBA". How you gonna use RegExp w/o VBA? And even if this were to allow VBA/UDF's, I would still call RegExp an advanced topic since it is not in the libraries one would normally use. You'd have to know of its existance from other programming experience. (Of course, you realize that if Nate reads this he's gonna have "no, no use a quick stack binary array!!!" ringing in his head -- but that's still VBA) So, yes, I guess I'm saying Intermediate-Advanced.

 

[Oaktree]

To be fair, Zack never said you had to use a formula... and, he only said from analphanumeric cell value.

You could tell by looking at 12ABC456DEF that the numerics are 12456.

I'd call that basic--even "remedial" Excel.