Formula Forensics No. 008 – Elkhan’s MaxIf
Today in Formula Forensics we look at how to Calculate the Maximum value from a list subject to other fields meeting certain criteria:
Formula Forensics. 009 – Pradhishnair’s Chainage Problem
A common Forum Post question and one that Chandoo has written about a few times is, Does my data overlap with another range?
This week Formula Forensics examines Pradhishnair’s Overlapping Chaninage Problem where he wants to know if two values overlap with a range of other values
Finding Friday the 13th using Excel (and learning cool formulas along way)
Not that I have friggatriskaidekaphobia or anything. But since today is Friday & 13th, lets put our Excel skills to test and find out when the next Friday the 13th is going to be.
2012 Calendar – Excel Template [Downloads]
Here is a new year gift to all our readers – free 2012 Excel Calendar Template.
This calender has,
» One page full calendar with notes, in 4 different color schemes
» 1 Mini calendar
» Monthly calendar (prints to 12 pages)
» Works for any year, just change year in Full tab.
Go ahead and download the FREE 2012 Calendar and Enjoy.
Using an Array Formula to Find and Count the Maximum Text Occurrences in a Range
Chandoo is off on Holidays and once again thrown me the keys to Chandoo.org.
So this week we’re going to:
- Pull apart an Array Formula and see what’s under the hood;
- Have a look at a technique for quickly developing Custom Number Formats &
- Look at how we can use HTML Codes in posts at Chandoo.org to spice up your questions and answers.
Today is Tarun’s Problem
“I have got multiple names in each row and would like to have what name is repeated maximum number of times and how many times?”
Today we pull apart an answer to this question and see how it works.
Sum of Values Between 2 Dates [Excel Formulas]
Lets just say, you run a nice little orange shop called, “Joe’s Awesome Oranges“. And being an Excel buff, you record the daily sales in to a workbook, in this format. After recording the sales for a couple of months, you got a refreshing idea, why not analyze the sales between any given 2 dates? […]
Check if a Word or Phrase is Palindrome using Excel Formulas [Weekend Fun]
The other day, while I was putting my kids to sleep, this idea came to me. How do I check if a cell contains a palindrome, using Excel formulas?
Next morning, I wrestled with excel for about 20 minutes and boom, the formula is ready.
But what is a palindrome?
A palindrome is a word, phrase, verse, or sentence that reads the same backward or forward. For example: A man, a plan, a canal, Panama!
So, to check if a cell contains palindrome, we need to reverse the cell contents and see if both original and reverse are the same.