All articles in 'Huis' Category

Today at Formula Forensics, we look at how to Count and Sum data using Criteria on Filtered data sets.

How can we Add Up the Odd numbers between 1 and 100 ?

Chandoo arrives in Perth, Australia.

Do you want to catchup with Chandoo (and Hui) for a Sundowner in Perth ?
Read here for details.

No, Not that Slash !

How do I find the 4th Slash in a text string?
Today at Formula Forensics we take a look at 4 different methods.

Pivot tables are a great way of summarising and consolidating data to produce summary reports.

One of the main limitations of Pivot tables is that they don’t natively return Text values.

This post looks at a method to work around this without the use of VBA.

Bhavik’s has presented us with a neat formula to determine how many working days are in a month.
This functionality has a wide range of uses in accounting, payroll, staff scheduling, accommodation planning & reporting and general scheduling activities.

Today in Formula Forensics we pull Bhavik’s Formula apart and see what is going on inside and the offer some extensions to increase the functionality of his formula.

I have imported some data that comes in as a number that I need to convert to h:mm. The data string will be either 1,3,4,5,6 integers long and looks like this…

Help

Over Easter, while we were all busy eating our Easter Eggs, at the Chandoo.org/Forums, Slk213 was worried about how to retrieve the Nth number from a row of data which had gaps in it.

Today in Formula Forensics we will look at how to solve this problem.

“I was trying to calculate the average DJIA # by month. I had the data by day so tried various combos (none of which worked) (:-”

Learn how to help Suzanne average the DJIA on a particular day and learn about a new Excel Function all in one post.

Cornelia wanted to cumulatively increases prices to a lot of products.
See how it was accomplished using an Array Formula to assist.

Did you know you can apply any text effect to a single character or group of text characters within a cell ?

This post will show you 2 quick tips to assist you in this technique.

“I have a large list which includes blanks, I want to retrieve the list without the blanks”
Faseeh, responded with a neat array formula.

Today Formula Forensics pulls Faseeh’s Formula apart to see what makes it tick.

Formula Forensics is on Vacation.

Formula Forensics is actually on a working Holiday and has visited the Excel Hero Academy this week.
So today in Formula Forensics we will showcase some of the work that have been derived from the learning’s at the Excel Hero Academy.

;
Today we look at a very neat way of doing a complex Nested If or Vlookup style problem with a simple but beautiful Sumproduct based formula.