I have a column that’s comprised of 26,483 cells. Each of these cells has the following date and time stamp data in it yyyy/mm/dd hh:mm:ss that records when an event first started. When I try to AutoFilter all the cells within this column I can’t do it because It doesn’t allow me to access all the dates that I need to apply filtering to, which is due to the fact the “Column has more than 10,000 unique items” within it.
MY QUESTION/REQUEST: Since I cannot reduce the amount of data that’s being captured in each cell because of the level of granularity I need to communicate in my final analytics report:
FILTER CRITERIA: The filtering criteria that I am trying to apply to each cell would be to include only those cells that fall within the time range of >=10:00:00 and <=21:00:00 for Monday through Saturday dates, and for Sunday dates >=11:00:00 and <=18:00:00.
Thanks for the your review and answer!
John
MY QUESTION/REQUEST: Since I cannot reduce the amount of data that’s being captured in each cell because of the level of granularity I need to communicate in my final analytics report:
- Is there a VBA work around for this sort/filtering issue? And if yes,
- Can you provide me with the VBA code that will do the sort/filtering?
FILTER CRITERIA: The filtering criteria that I am trying to apply to each cell would be to include only those cells that fall within the time range of >=10:00:00 and <=21:00:00 for Monday through Saturday dates, and for Sunday dates >=11:00:00 and <=18:00:00.
Thanks for the your review and answer!
John
