LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 144
Default Creating number from groups of numbers

If someone could help me with this I would really appreciate it.

If you have three sets of numbers. Say in Column A you have 1 2 & 3 in
Column B you have 4 5 & 6 and then in Column C you have 7 8 & 9.

Is there any way to see all the variations of numbers you could come up with
if you used one number from each Column. For example starting with the
number 1 in Column A you could end up with 9 different numbers, see example
below. Also, they have to be in order, so Column A number always has to be
in first place, Column B in second place and Column C in Third.

The data set I am using is much larger which is why I'm looking for a way to
handle this. Any help will be appreciated. Thanks.
147
148
149
157
158
159
167
168
169

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert numbers from text format to number format merlin68 Excel Discussion (Misc queries) 7 June 20th 07 07:03 PM
Non updatable Unique Random Number Ian Excel Worksheet Functions 30 September 28th 06 08:19 PM
Is this possible ??? DB Excel Discussion (Misc queries) 12 August 26th 06 12:19 AM
Assign number to groups of same numbers Mike Excel Discussion (Misc queries) 2 August 11th 06 08:35 PM
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com Excel Worksheet Functions 33 April 4th 05 02:17 PM


All times are GMT +1. The time now is 04:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"