I am looking for a way for the text cells in Col.A to be listed in B2 ignoring any duplicates
In column A there will be a number of words and I want to list each one once in B2
e.g.
A1 "word one"
A2 "word one"
A3 "word two"
A4 "word two"
A5 "word two"
A6 word two
B2: "Word One", "Word Two", Word Two
Thanks
Last edited by Chrisbrough88; 08-12-2014 at 02:22 PM.
deleted didn't see this was vba forum
Last edited by martindwilson; 08-12-2014 at 02:25 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
The number of words per cell and number of rows will differ each time depending on what I need to search for and how many results there are
Thanks
see the udf in post #12 here
http://www.excelforum.com/excel-form...ue-values.html
use as
=TRIM(ConcatUniq(a1:300,","))
it may look like you cant see all the text but if you make the cell mush bigger you should see it all
or copy paste into notepad
Last edited by martindwilson; 08-12-2014 at 03:09 PM.
unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules.
http://www.excelforum.com/excel-form...xt-values.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks