Formula Forensics No. 030 – Extracting a Sorted, Unique List, Grouped by Frequency of Occurrence
Today at Formula Forensics, Guest author Sajan shows us how to extract a sorted, unique list of items, displaying the most frequently occurring items first, while restricting the output based on some additional criteria.
Formula Forensics 024. Is this number a Prime Number ?
Is my number a Prime Number?
What is a Prime Number?
Today in Formula Forensics we answer both questions.
Highlight Row & Column of Selected Cell using VBA
When looking at a big table of analysis (or data), it would make our life simpler if the selected cell’s column and row are highlighted, so that we can instantly compare and get a sense of things. Like above.
Who doesn’t like a little highlighting. So lets learn how to do highlighting today.
Formula Forensics 023. Count and Sum a Filtered List according to Criteria
Today at Formula Forensics, we look at how to Count and Sum data using Criteria on Filtered data sets.
Formula Forensics 022. Sum the Odd Numbers between 1 and 100
How can we Add Up the Odd numbers between 1 and 100 ?
Formula Forensic No. 021 – Find the 4th Slash !
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.
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.