Find cell address of dates listed in column based on match

[jprlimey]

I have a column of dates formatted as MM/DD/YYYY HH:MM AM/PM, the worksheet has been sorted in oldest to newest order. I can have as many as 1440 recordings for 1 day (every 1 minute) but some day's could be missing data due to malfunctioning equipment.

Ideally what i want to do is create a scatter chart for each day's data, the chart would have a maximum of 7 days to make it readable. With each date having the potential for variable number of inputs assigning the chart series becomes painful.

I thought that if I were to list the unique dates in a separate column then i could write a formula to find the minimum and maximum cell address for each date, this would make it much easier to define each series in the chart.

Any suggestions?

[protonLeah]

Data, Advanced Filter, Copy to new location, Unique records

[jprlimey]

Data, Advanced Filter, Copy to new location, Unique records

I don't see how your suggestion will work when the cell address is still unknown.

I have attached a file that might help explain further. In the file i have manually input the cell address of the minimum and maximum dates per the unique dates shown in column C. Want i need is a formula that will tell me what the cell address is.

[kvsrinivasamurthy]

Pl see atached file.

[jprlimey]

Fantastic, just what I'm looking for, thanks for your assistance

[kvsrinivasamurthy]

Thanks for the compliments. Pl mark the thread solved.