Filter values based on numerical ranges
Eero S asks: Thank you *so* much for your detailed examples and actively replying to users! I have a problem, […]
Find last value in a column
The formula in cell D3 lets you get the last value in column B, it works fine with blank cells […]
Find last matching value in an unsorted table
DonW asks: Ok, you've shown it for regular ranges....how about within tables. I have a table similar to: ID Name […]
How to use the LOOKUP function
Finds a value in a sorted cell range and returns a value on the same row.
Find last matching value in an unsorted list
I read an interesting blog post Find Last Item in Group With Index Match written by Debra Dalgleish. It is about […]
How to return a value if lookup value is in a range
In this article, I will demonstrate four different formulas that allow you to lookup a value that is to be found […]
5 easy ways to extract Unique Distinct Values
First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]
Last value in column
Last value unsorted list
Lookup value in rng
Most used functions
Weekly Blog EMAIL
Get a FREE PDF book!
Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.