I have a list of names with a variable number of occurrences identified by year, and for each name a total (of other columns) record:
NameA 1960
NameA 1961
NameA Total
NameB 2004
NameB 2005
NameB 2006
NameB Total
NameC 1957
NameC 1960
NameC 1964
NameC Total
NameD 2018
NameD Total
I want to report separately the first year for each unique name listed elsewhere (easy, using vlookup) and the last year for each name.
This I am having a problem with and cannot find a solution within the forum.
Can someone help please? My best solution so far is to sort by year, and then sort descending those records that do not include total and then use vlookup again. I need it to immediately reflect any changes to the file.
I am using Excel 16 on Windows 10. Sample file attached.
Thankyou in advance.
Bookmarks