Advanced Filtering

[seguin85]

Hi All,

I have a sheet with names and other personal information from columns B-M.

I have dates for each day from rows N-JA.

What I want is to be able to set up a filter that will show if a non-blank value shows up in a certain date range.

Example: for June 15-August 1 I want to filter if any row within that date range.
So if employee 1 is scheduled to work on any of those days he/she will be shown.

 

[seguin85]

but I would start formatting your table into a proper table. I deal with clients where they put their data into formats like this and it only ever creates extra work. It isnt even practical for a human to read in this manner. You should have a header and take advantage of simple filtering... the table format causes unnecessary complications.

I dont know what advanced filtering is but if you create a true/false helper column like described then you just have that return true or false if row is blank and you filter by that.

Can't the date be my header? You think I should set up my data like:

Name	#	Date	Type
John	1	5/12/17	M
John	1	5/13/17	S
John	1	5/14/17	M
John	1	5/17/17	M

<tbody>
</tbody>

 

[Marcelo Branco]

Thanks, I used the helper column (great idea and very easy to implement). I added a macro and attached it to a button to I don't have to scroll all the way to the right of the page to filter by the helper column.

You are welcome. Glad to help

M.

 

[cerfani]

Can't the date be my header? You think I should set up my data like:

Name	#	Date	Type
John	1	5/12/17	M
John	1	5/13/17	S
John	1	5/14/17	M
John	1	5/17/17	M

<tbody>
</tbody>

yeah i think this makes analyzing data so much easier. It is a standard in the database world. Database 101

https://support.office.com/en-us/article/Introduction-to-tables-78ff21ea-2f76-4fb0-8af6-c318d1ee0ea7

A relational database like Access usually has several related tables. In a well-designed database, each table stores data about a particular subject, such as employees or products. A table has records (rows) and fields (columns).

Fields have different types of data, such as text, numbers, dates, and hyperlinks.

You are listing each date as a field!! A field should be a data type not the data itself. You should have a field for the date.