View Single Post
 
Old 10-26-2017, 05:24 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

How about using slicers?

First, you would have to convert column A to copy down dates to fill all rows.

Then you add column Headers (you can hide this row)

Convert range to Table

Then Insert Slicer based on Date in column A.

Now you just click the date you want and presto.

To get all dates you click the little "funnel with X through it" icon
Attached Files
File Type: xlsx Copy of esempio.xlsx (16.4 KB, 11 views)
Reply With Quote