M
Mark R
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
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