Attached is an example. Sheet1 has 3 columns of data. Date, Name, Location
What I need is on sheet 2 to dynamically generate a list of the unique names by location for any date entered in the "date" block.
I think this would work best if it were a formula just so it is more "dynamic" and can update without having to run a macro each time the date is changed, however, I could make a macro solution also work.
Thanks in advance,