=IF or =VLOOKUP: Find all cells that contain a date and create a list of dates

Hi,

I created a spreadsheet into which I enter certain data for swimmers to track their progress. I would like to extract some of the data to create a graph.

For this, I need excel to search a column and find all cells that contain a date and then list those dates in order. Then, by using those dates I would like to extract data and place it in adjacent cells. Once that is done, it will be simple to create graphs to visually display the swimmers’ progress.

I hope someone will help!

Thank you in advance!

 

 

 

By: Jaco

Leave a Reply

Your email address will not be published. Required fields are marked *