Do you just want to create a reference number as a one off allocation type thing? Will your list of names be entirely unique or do you want it to recognise duplicates? As Simsy says, really need a little more info. If you just want to type a unique name in a cell and have Excel generate a new sequential reference number, that is easy. But sounds too easy.