double > unique numbers!

[stewart08]

should be simple, need help on a formula that turns doubles into unique numbers example:

7788873 = 783

PS each number is in a cell each....

[stewart08]

any takers

[stewart08]

let me know if you need any more help...

[stewart08]

at the moment I am trying to use the match function...any ideas

[stewart08]

this maybe be a simple task...but I'm finding it very hard to do
I need a formula that convents repeated digits into unique digits example:

787 = 78

or

7788735 = 7835

each value has its only cell.
being at it for days now....any ideas

[shg]

Threads merged.

Stewart, please don't open a second thread on the same topic.

[daddylonglegs]

Are you saying that 7788735 is in a single cell....or that each digit is in its own cell? What's the maximum length of the number? You want the result in a single cell?

[stewart08]

daddylonglegs, yes.....each digit is in a cell each, with 6 numbers to search from...and also each digit result in a each cell.

[daddylonglegs]

Here's one way....but it's a bit of a complex formula.....

Assume you have up to 10 digits in A1:J1 and then K1 is blank. Use this formula in L1

=IF(SUM(($A1:$J1<>"")/COUNTIF($A1:$J1,$A1:$J1&""))<COLUMNS($K1:K1),"", INDEX($A1:$J1,MIN(IF(ISNA(MATCH($A1:$J1,$K1:K1,0)),COLUMN($A1:$J1)-COLUMN($A1)+1))))

confirmed with CTRL+SHIFT+ENTER and copied across to Q1

[stewart08]

ok daddylonglegs, I followed your steps with CTRL+SHIFT+ENTER.

sort of works i.e.

1122334334 = 1232

should return = 1234

could you post a attach file please....

[NBVC]

following daddylonglegs' instructions I got the desired result of 1234..

[stewart08]

get it working now