Find the last date of an activity
We know that using VLOOKUP, we can find a value corresponding to a given item. For example Sales of x. But what if you have multiple sales for each item and you want the last value?
Today lets understand how to find the last date of an activity, given data like above.
Like everything else in Excel, there are multiple ways to finding last date. If cats can use computers, they would hate Excel. You see, Excel is overflowing with unlimited ways to skin a cat.
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 Forensic No 019. Converting uneven Text Strings to Time
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
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.
Formula Forensics 013. – On Vacation
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.
Formula Forensics No. 010 Count How Many Times a List of Values Occurs in a Range
Count How Many Times a List of Values Occurs in a Range
(or How Can I Simplify My Formula)
Today in Formula Forensics we look at how to count how many times a range of values occurs within a Range of cells and in the process simplify a very nasty formula.
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