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
Bookmarks