|
Posted to microsoft.public.excel.misc
|
|
|
copying data from a list
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
|