News

Able to compare numerical and text values ... chances are you can pipe that output into another function to accomplish even more. Using Excel creatively is a rewarding, and dare I say fun ...
Excel's INDIRECT function turns a text string into a reference ... Notice how we've used quotes around the column reference, as we're using that text to create a cell reference.