Find date range based on a date
Filter duplicate values using critera
Create a list of duplicates where adjacent cell value meets a condition
Vlookup and return multiple values
Search and return multiple values
Extract unique distinct records from two data sets
Filter unique distinct records using criteria
Filter unique distinct records
Weekly Blog EMAIL
Get a FREE PDF book!
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup
Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Extract records containing digits [Formula]
Liam asks: Hello Oscar, What code is needed to cause cells in Columns F - I to fill with the […]
Filter records based on a date range and a text string
Murlidhar asks: How do I search text in cell and use a date range to filter records? i.e st.Dt D1 […]
Match two criteria and return multiple records
Question: I have a table of 3 columns (Security name, date, price) and I have to find the price of […]
