Good day,
You can now put images inside of cells in Excel and return them using regular lookups, such as vlookup, xlookup, filter function, etc. It allows you to do some pretty useful things in Excel, including make searchable lists and dashboards a lot more uesful. (View Tutorial)
SMS Updates
We now send weekly SMS for new tutorials and courses.
Add your number if you'd like to get these weekly updates.
Can’t see the thumbnail? Click here to watch on YouTube
Last Week's Video: Wrapping Columns in Excel?!
[Tiny Tip] Filter Results Between Two Dates
The FILTER function can quickly return the rows that fall between a selected start date and end date.
1. Set Up the Dates
For this example:
The full dataset is in A2:C100.
The dates are in A2:A100.
The start date is entered in E2.
The end date is entered in F2.
2. Enter the FILTER Formula
Enter the following formula in an empty cell:
=FILTER(A2:C100,(A2:A100>=E2)*(A2:A100<=F2),"No results")
Excel will return every row with a date that falls between the dates entered in E2 and F2.
How It Works
A2:A100>=E2 checks whether each date is on or after the start date.
A2:A100<=F2 checks whether each date is on or before the end date.
The multiplication symbol * tells Excel that both conditions must be true.
Update the Results
Change either date in E2 or F2, and the filtered results will update automatically.
Excel AI for Fixing Macros
Courses
Cheers and see you next week!
Don