* For deriving campnames automatically, enter this into all cells; it may require SHIFT-ENTER or CTRL-SHIFT-ENTER to activate it (try it first on a camp row) but copy and pasting works fine. =IF(G14="","",CONCATENATE("camp",TEXT(SUM(1/COUNTIF(G$2:G14,G$2:G14))-1,"000"))) It's quite slow, so once the final camps are set, then it should be replaced by the actual 'campXXX' text.