Daily posts of Excel tips…and other stuff
Archive for the ‘Filtering’ Category.
I need a quick way to create a filter by month on an autofiltered range. Right now I'm manually entering this:
That's tedious. One option is to create another column with just the month and year in it and filter on that, but I don't like my data cluttered. So I wrote this [...]
Hi all
After creating and testing a lot of code to filter on normal and on Conditional Formatting colors
I came up with a nice and easy solution I think.
I made this page for Excel 2007
http://www.rondebruin.nl/colorfilter2007.htm
Suggestions are welcome
Ron de Bruin
http://www.rondebruin.nl/tips.htm
El Says:
"I have a spreadsheet with dates and on each day, there are several activities with start time and end time. I want to add a row between each day, and also to add up the total time for all the activities in each day."
This is where the Subtotals feature is quite useful.
It can add [...]
Hi all,
Today I published my first article dedicated to Excel 2007 on my site.
The article is about Excel 2007's new Table feature and is aimed at the beginner Excel 2007 user (that would be just about everyone except John Walkenbach ).
From the intro:
With the release of Excel 2007, Microsoft has introduced a new [...]
One of Excel's features which I use frequently is the Advanced Filter - Unique Values.
It's pretty handy for analysing data and building summary / master tables.
From Excel's menu: Data > Filter > Advanced Filter...
Copy to another location = selected.
List range: Select the list of values you want to see unique. Include the heading.
Copy to: Select [...]
Hi all
I have upload Easyfilter 2.1 Beta to my site with a Color tab.
It is not working on CF colors (this is the next step).
You can filter on Fill, Font colors and on bold cells.
Comments good or bad are welcome about this Beta version.
You can find it here (on the bottom of the page)
http://www.rondebruin.nl/easyfilter.htm
Ron de [...]
Hi all
Together with Norman Harker and the late Frank Kabel I have create EasyFilter 2.0.
This version have a special Date tab with a lot of Date filter options.
I hope it is useful for a lot of Excel users.
This Version of EasyFilter is dedicated to the memory of Excel MVP Frank Kabel.
We will miss him very [...]
The Advance Filter feature (Data > Filter > Advanced Filter) can be used to filter a list based on the criteria range you specify. For instance, to find the week that Team3 hosts Team4 on a schedule, your worksheet might look like this:
The result being one time in Week 1.
The criteria you specify contains [...]
