I have this on a1 downwards
BRANCH1
BRANCH2
BRANCH2
BRANCH2
BRANCH3
BRANCH3
BRANCH3
I want on b1 downwards unique as
BRANCH1
BRANCH2
BRANCH3
I have this on a1 downwards
BRANCH1
BRANCH2
BRANCH2
BRANCH2
BRANCH3
BRANCH3
BRANCH3
I want on b1 downwards unique as
BRANCH1
BRANCH2
BRANCH3
I also know remove duplicates , but I want through formula , since I have a formula linked to that
so removed duplicated does not help
unique list through formula
if you type unique list through formula into google the first result is this :D
http://www.get-digital-help.com/2009...om-one-column/
LordLoki , thank you , useful link
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks