• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

want numbers in pairs

Nabeel

I am glad that Narayan has found you a solution

Nowhere in your descriptions have you mentioned to generate a list of numbers and so it appears that you wanted the list in Column A re-arranged, swapping the middle x numbers for the last y digits and vise versa, which could have been done with either VBA or a formula, probably simpler with VBA

When asking questions you have to assume that we know nothing of your problem or your business.

Explain the question as you would to a totally naive person
 
HUI
i respect your opinion and expertise, some time mind did not match but any how you all of providing good solution and doing great job for people like me..

Nabeel
 
Hi ,

See the attached file ; I am not sure I have listed all the possible numbers , so check thoroughly.

I might not be able to do anything more tonight , since it is late for me ; I can reply only tomorrow.

Narayan
 

Attachments

  • couple sample2.xlsx
    20.9 KB · Views: 2
thnx NARAYAN bro

much appreciated your skill and knowledge..only missing in all with starting and ending 0 for golden,silver and plat..once more thnx

Nabeel
 
Dear Narayan brother
need your expertise once again..need one formation more 1110111,2220222,3330333 so on and 1112111,2221222,3331333 so on , in same prefix
Nabeel
 
sorry Narayan
sorry for disturbing
one is missing 1110222,1110333 and 0001000,0002000 and 0001222,0001333

pl help

NAbeel
 
Hi ,

Some of them have been incorporated , but the others are in a different pattern. Please start a new thread for this. I am not in a position to reply for at least a week.

Narayan
 

Attachments

  • couple sample2.xlsx
    35.3 KB · Views: 4
Hi Narayan

in last attached sheet most of a has given to me..may 0 are incorporated ,can we go with this...1112333, 1114333 and 2221333,2223444

Nabeel
 
Back
Top