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!