Hello all
I have a spreadsheet with people and years.
Column A is the year
Column B is the name of the person
Column C is where I would like the earliest year that person appears in the spreadsheet
Column D is where I would like the latest year that person appears in the spreadsheet
(There are other columns which aren't relevant to this query)
For example
John Smith could be in the spreadsheet 50 times from 1950 to 2000 - I would like C to show 1950 and D 2000
Jane Dow could be in the spreadsheet 5 times from 2010 to 2015 - I would like C to show 2010 and D 2015
Can you help?
Thank you in advance.
Bookmarks