-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Kenneth Hobson
Well-known Member
- Joined
- Feb 6, 2007
- Messages
- 3,181
- Office Version
- 365
- Platform
- Windows
Welcome to the forum!
idk what you mean by between. You mean some column with values >7 and < 8? That would be two criterion which is maximum for one field/column. If you want more, autofilter is not the right tool.
idk what you mean by between. You mean some column with values >7 and < 8? That would be two criterion which is maximum for one field/column. If you want more, autofilter is not the right tool.
Upvote
0
Thank You Kenneth !
I have a call center data set for a month with columns stating the time a call is made. I am trying to automate and isolate the data by how many calls are made between 1m to 8am, and then 8 am and 9 am, and so on. You are right, I am looking for multiple criterion, which tool will be best for this scenario ?
Thanks
Rush
Upvote
0
Kenneth Hobson
Well-known Member
- Joined
- Feb 6, 2007
- Messages
- 3,181
- Office Version
- 365
- Platform
- Windows
You can use formulas to get counts if that is your goal.
If you want to just look/filter by a time period, the autofilter method for one period will suffice.
Or, you can do both. IF you wanted multiple intervals filtered at once, toadstool's helper column method will be needed for autofilter or a criterion table for the advanced filter method to filter-in-place.
If filter is needed for each time period, a macro for each interval period would do it quickly. Of course adding the criterion manually is easy but not as-fast-as a macro.
Another option might be to use conditional formats. That would show the time periods but it will not be continuous. It might give you a good feel for the data. A sort might be a good way to visualize the data when combined with conditional formats.
Once you decide on the goal(s), you can post a link to a shared site like dropbox. The simple file would have obfuscated data if needed. The file might make helping you easier and more tailored to your data.
If you want to just look/filter by a time period, the autofilter method for one period will suffice.
Or, you can do both. IF you wanted multiple intervals filtered at once, toadstool's helper column method will be needed for autofilter or a criterion table for the advanced filter method to filter-in-place.
If filter is needed for each time period, a macro for each interval period would do it quickly. Of course adding the criterion manually is easy but not as-fast-as a macro.
Another option might be to use conditional formats. That would show the time periods but it will not be continuous. It might give you a good feel for the data. A sort might be a good way to visualize the data when combined with conditional formats.
Once you decide on the goal(s), you can post a link to a shared site like dropbox. The simple file would have obfuscated data if needed. The file might make helping you easier and more tailored to your data.
Last edited:
Upvote
0
