Dear Sir,
I am new in this site my question is that i have a file in which i need pair a mobile no into 10 columns now i am sending you a attachment in which mention my problem i hope you will understand it.
Only i need that how much pair can be made like.
123
1-2
1-3
2-3
Above example in 2 columns if there is large numbers then i need it in 10 columns please help me as soon as you can.
Thank You
Ravan Return
This is not really an excel problem, more of a programming problem. You would need to use VBA if you wish to have this done in Excel. Also, I don't understand the use of this data. If your input is 10 numbers, then that means there are 10! combinations. That is more rows than Excel can support and (likely) more than you want to view.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Dear Sir,
I have lots ** excel workbook in which customer name his mobile no are mention and i want to collect all workbooks data in one excel workbook.
Please help me and also tell me that how you do this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks