Numbers in Pairs formation

[gondal]

Hi all

PFA..i need mention type of pairs max which can be made in column P and Q, 1110222,1110333,so on and reverse of it 2220111, 3330111 so on and 0001000,0002000 and 0001222,0001333 and also reverse of it too...

already some formation and formulas in columns like "E" to "O" and in column "C" that is prefix which i changed to 321,322,320 ect..

Gondal

[Kaper]

Hi Gondal,
Try in P1:

Please Login or Register  to view this content.

I focused on this part of your description:

1110222,1110333,so on and reverse of it 2220111, 3330111

If you look for something else, my advice would be:
In a sample workbook make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed. Make sure your desired results are shown, mock them up manually if necessary.

[gondal]

hi Kaper
no i do not need like this, i need result 321 1110222, 321 1110333 so on and your formula is reversing the column "K" pairs

Gondal

[Kaper]

So it is enough to notice that difference is 111 and add it to previous number, then add again to result. But I'm sure you know this, so see http://www.excelforum.com/forum-rule...rum-rules.html and especially first bullet point under numbered rules.