Hello,
I have been trying to search for a simple answer to this but at the moment I'm stuck.
I have 4 cells each with a range of numbers representing days of the week.
For example in D1 12345
D2 1
D3 456
D4 17
I need a formula that can list these as one figure removing any duplicates so the the above example the resulting figure should be
1234567
Is this possible ot do I need to go to VBA to achieve this.
THanks for taking the time to look.
Regards
David
Hi
One way is using text to columns to split the numbers in different cells and then using formulas get the result.
But this needs extra columns. Are you interest for something like this?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I'm open to suggestions, I can always hide the extra columns
In this case take a look to the example.
UniqueNumberstring.xls
Hi Fotis,
Thanks for the help again, what I should have mentioned was that the 4 numbers are variable. But your spitting into columns idea helped. I used the attached which seems to work.
Thanks Again
David
You are welcome David.
The only point that i noticed in your solution is that if you put in cells A1:D1, a number that is bigger than the biggest number of the range, then does not work. I mean if you put 8 OR 9 in these cells..
But maybe this isn't problem for you.
Re: Matching Unique numbers if a Group of cells
No, this won't be an issue as 7 will be the highest number as they represent days of the week.
Understoond
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks