All articles with 'N()' Tag

3D Max Formula for Excel

Published on Sep 9, 2014 in Excel Howtos, Learn Excel
3D Max Formula for Excel

We all know about the MAX formula. But do you know about 3D Max?

Sounds intriguing? Read on.

Lets say you are the sales analyst at ACME Inc. Your job involves drinking copious amounts of coffee, creating awesome reports & helping ACME Inc. beat competition.

For one of the reports, you need to find out the maximum transactions by any customer across months.

But there is a twist in the story.

Your data is not in one sheet. It is in multiple sheets, one per month.

Continue »

Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 2.)

Published on Jul 17, 2013 in Formula Challenges, Posts by Jeff

Today we look at the third place winner from our inaugural Formula Challenge, a neat solution provided by Sajan.

Continue »

Formula Forensics No. 032 – Creating Dynamic Charts with Non-Contiguous Data

Published on Dec 4, 2012 in Formula Forensics, Posts by Sajan
Formula Forensics No. 032 – Creating Dynamic Charts with Non-Contiguous Data

There are many web pages devoted to Excel Charts and there are many web pages devoted to Creating Dynamic Ranges, but a lot of these suffer when the data is poorly organised or non-contiguous.

Today we look at a Technique for Creating Dynamic Charts with Non-Contiguous Data.

Continue »