Hi gang!
Sorry about that title if it doesn't explain this well!
I have a bunch of years in column G like this 5 row example:
1950–1953
2023
1950, 1956–2019, 2021
1950–1951, 1953–1954, 1956, 1959–1961, 1964, 1966
1990, 1992, 1999
I want to convert these to individual year columns. I've got columns J through CE set up to capture these years starting with 2023, working backward to 1950. I want a Y shown in the respective cell where that year is listed in column G.
It's the ranges that are tricky for me (1950–1953); if it was just a listing of each individual year in the same cell (1950, 1951, 1952, 1953), I think I could do it.
Is there an easy way to do this, or do I have to do it manually? Thanks!
Sorry about that title if it doesn't explain this well!
I have a bunch of years in column G like this 5 row example:
1950–1953
2023
1950, 1956–2019, 2021
1950–1951, 1953–1954, 1956, 1959–1961, 1964, 1966
1990, 1992, 1999
I want to convert these to individual year columns. I've got columns J through CE set up to capture these years starting with 2023, working backward to 1950. I want a Y shown in the respective cell where that year is listed in column G.
It's the ranges that are tricky for me (1950–1953); if it was just a listing of each individual year in the same cell (1950, 1951, 1952, 1953), I think I could do it.
Is there an easy way to do this, or do I have to do it manually? Thanks!