Tag Archives: MAX

Apply Conditional Format for alternate row color based on groups…

…that works even when filter is applied. The situation: We have a table that we would like to apply color banding based on groups.  We can achieve this by inserting a helper column to identify the sequence of each group, … Continue reading

Rate this:

Posted in Formula | Tagged , , , , | Leave a comment

Using MIN/MAX to answer whichever lower/higher questions

What is “Whichever higher”? Situation: You call to your favourite restaurant to reserve a private room for family dinner on Saturday.  The restaurant manager tells you that there will be a minimum charge of $2000 for a private room.   That mean, … Continue reading

Rate this:

Posted in Formula | Tagged , , | Leave a comment

How to calculate number of overlapping days for two periods?

Have you ever encountered a situation that you need to find out how many days in Period 2 fall into Period 1? Is using IF(IF…(IF…(IF…(IF….. the first thing in your mind?

Rate this:

Posted in Formula | Tagged , , | 10 Comments