Formula Forensics No. 017 – A Solution to Maljzm’s problem.
Today Faseeh, from the Chandoo.org Forum, joins Chandoo.org as a contributor with his first post.
Faseeh, helps find a solution to Maljzm’s problem of looking up time values from a list and comparing them to determine if a value meets some criteria.
Formula Forensics 016. Suzannes DJIA Average
“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.
Formula Forensic 014 – Faseeh’s Formula
“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.
Cleaning Up Imported Data – A Recent Case Study
Houston, We’ve Had a Problem!
In the initial emails requesting a solution to yesterday’s Formula Forensics, Chandoo’s solution, although Technically correct, Didn’t work ?
This post looks at the problem and what was wrong with the data causing the error.
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
Formula Forensics 006. Palindromes
Palindrome: – A palindrome is a word, phrase, number, or other sequence of units that can be read the same way in either direction, with general allowances for adjustments to punctuation and word dividers (“Wikipedia”).
This week in Formula Forensics we’re having a look at determining if a cell contains a palindrome.