Tag Archives: MrExcel

Conditional Average On Non-Contiguous Ranges Using FREQUENCY()

At the beginning of the year I talked about the FREQUENCY() worksheet function and gave a handful of examples on how it can be used. Today’s article is another, brilliant FREQUENCY() example which was posted by Barry Houdini on the MrExcel board. I’ve … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , , | 8 Comments

VLOOKUP Week

Bill Jelen is dedicating 25th – 31st March to one of Excel’s most popular worksheet functions: VLOOKUP. In addition to  doing VLOOKUP themed podcasts, e-book excerpts and drawings over at his MrExcel.com website, he’s also going to curate all the VLOOKUP Week posts from across … Continue reading

Posted in Microsoft Excel | Tagged , , | 5 Comments