ExcelTips (ribbon) for 24 October 2026
Having trouble reading this issue? View it on our website.
I hope your weekend is going well and that you enjoy the tips in this week's newsletter.
ExcelTips (ribbon) for 24 October 2026
Understanding the FILTER Function
The FILTER function allows you to filter a range of data based on criteria you define and extract matching rows into a new dynamic array. This provides a handy way to do your filtering directly within a formula instead of with Excel's traditional filtering tools.
Alerts About Approaching Due Dates
You may use Excel to track due dates for a variety of purposes. As a due date approaches, you may want that fact drawn to your attention, in some fashion. This tip examines different approaches you can take to getting the alert.
Are You Foundering at Filtering?
We have all experienced the frustration inherent with using Excel filters. Stop foundering when filtering your data by getting your copy of ExcelTips: Filters and Filtering today. More info available online.
Weird Mouse Shortcut
If you like to use the mouse in your worksheet navigation efforts, you'll want to pay attention to this tip. Here you discover a way you can navigate using the mouse and the borders of the selected cell.
Adding Differently Formatted Text to a Cell
Want to add or replace some text in a column with text that is formatted differently? The ideas presented in this tip can go a long way toward accomplishing your task.
Help Wanted
This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.
If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.
Getting a Project Count for Days in a Month
I have a worksheet where each row contains information about a project, including a start date and end date for the project. I would like a summary that showed a count of projects active during each date of a particular month. If the start dates are in column C, the end dates in column D, and the date for the month in question is in cell S1, how can I get a project count for each day in that month starting in cell S5?
—Dennis Franklin (provide an answer for this Help Wanted question)
PO Box 211
Mesquite NV 89024
USA