Screen Shot 2017-09-21 at 10.47.56.png


Hi I need help,

I need the Sample.ID to correspond to date.

i.e, Date - 2009 = PACE01-612
Date - 2011 = PACE02-612
Date - 2012 = PACE03-612

The spreadsheet is much bigger than screenshot, I have been trying to do this manually,but I'm sure there is a formula I can use to help.

I would appreciate your help

Thanks,
Jordan