Thanks Bob and Arvi. I'm sorry for not attaching a sample sheet on which the readers could try and find a solution to my request. The IF formula required a helper column but it's okay. BTW I added IF birth year is 2000, 2000.
I will try the validation list and file it for future reference. I filtered those years below 1930 and retyped the 4 digit years.
|