TheOddGirl
New Member
- Joined
- Apr 1, 2018
- Messages
- 11
I have a spreadsheet with 20,000 rows of data that I need to get the earliest and latest dates into one row.
Example, for Shop1 I would need the start date to be 01/01/2018 and the end date to be 05/04/2018 recorded in a column to the right so I can sort by that column and get rid of data that I don’t need. Can anyone offer any help with this please?
[TABLE="width: 289"]
<tbody>[TR]
[TD]ShopID[/TD]
[TD]ShopName[/TD]
[TD] Startdate[/TD]
[TD] Enddate[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name1[/TD]
[TD]01/01/2018[/TD]
[TD] 05/02/2018[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name1[/TD]
[TD]01/03/2018[/TD]
[TD] 05/04/2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Name2[/TD]
[TD]01/01/2017[/TD]
[TD] 05/02/2017[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Name2[/TD]
[TD]01/07/2017[/TD]
[TD] 05/09/2017[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Name3[/TD]
[TD]01/01/2018[/TD]
[TD] 28/02/2018[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Name3[/TD]
[TD]01/03/2018[/TD]
[TD] 30/10/2018[/TD]
[/TR]
</tbody>[/TABLE]
Example, for Shop1 I would need the start date to be 01/01/2018 and the end date to be 05/04/2018 recorded in a column to the right so I can sort by that column and get rid of data that I don’t need. Can anyone offer any help with this please?
[TABLE="width: 289"]
<tbody>[TR]
[TD]ShopID[/TD]
[TD]ShopName[/TD]
[TD] Startdate[/TD]
[TD] Enddate[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name1[/TD]
[TD]01/01/2018[/TD]
[TD] 05/02/2018[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name1[/TD]
[TD]01/03/2018[/TD]
[TD] 05/04/2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Name2[/TD]
[TD]01/01/2017[/TD]
[TD] 05/02/2017[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Name2[/TD]
[TD]01/07/2017[/TD]
[TD] 05/09/2017[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Name3[/TD]
[TD]01/01/2018[/TD]
[TD] 28/02/2018[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Name3[/TD]
[TD]01/03/2018[/TD]
[TD] 30/10/2018[/TD]
[/TR]
</tbody>[/TABLE]