Thanks toppers, i didnt find th link that useful - a bit complex.

is their not a single formula that looks at a list and then takes a single
entry from the list and populates my new list without duplicating entries

"Toppers" wrote:

Take a look he

http://www.cpearson.com/excel/ListFunctions.aspx

"Mark R" wrote:

I have a spreadsheet that I add new data too. I want to produce a list on a
seperate worksheet that takes the names from the list and puts them in a new
list, but I dont want to duplicate. ie

Abbey
Natwest
Abbey
BOS
Natwest
Halifax

So I would like the formula to look at that list and produce the following

Abbey
Natwest
BOS
Halifax

and also to update as I add new names