Need formula to create pairs from a string number row.

Reply #5

frenchie — Fri, 23 Dec 2011 22:06:09 GMT

Hello Winsum,

Thank you for the reply, it is close to what I need and your formulas works fine , thank you.

What I'm looking for is one formula that I would put in cell R10 and just drag to the right, up to AZ10 and would eather return all pairs if all the 9 digits are there or return blanc cells if there is less digits to deal with.

And the same for the duplicate one.

I know it's possible but I'm not qualify for such formula !!!.

Thank you.

Serge.

Reply #4

winsumloosesum — Fri, 23 Dec 2011 13:37:01 GMT

Not sure if this is what you wanted frenchie

http://www.box.com/s/4xs9hpovuhzy2z20h80x

Reply #3

frenchie — Thu, 22 Dec 2011 05:33:09 GMT

Here is the simple file.

http://cjoint.com/?0LwgGq3r6Ul

Thank you.

Serge.

Reply #2

frenchie — Tue, 20 Dec 2011 20:31:32 GMT

How can I post a piece of my spreadsheet to show the display

Reply #1

RJOh — Tue, 20 Dec 2011 20:25:13 GMT

Seems like that formula have a lot of variables repeat, you probably can remove some of them and forget about that background-color, if the formula works it doesn't have to look pretty too.

Need formula to create pairs from a string number row.

frenchie — Tue, 20 Dec 2011 20:16:23 GMT

Hello everyone,

I'm looking for a formula that will create pairs from a row.

Thank you for any help.

Serge.