| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel number sequencing formatting
I am using MS Excel and want to have 4 sets of numbers only be available in
the cells I pick. The numbers and sequence of these numbers are first set. 1,2,4,3. Second set 2,4,3,1.Third set 4,3,1,2. four 3,1,2,4. Thanks Jim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel number sequencing formatting
Do you mean that a single cell should contain either 1,2,4,3 or 2,4,3,1 or
4,3,1,2 or 3,1,2,4? Stefi €˛Jim M€¯ ezt Ć*rta: I am using MS Excel and want to have 4 sets of numbers only be available in the cells I pick. The numbers and sequence of these numbers are first set. 1,2,4,3. Second set 2,4,3,1.Third set 4,3,1,2. four 3,1,2,4. Thanks Jim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel number sequencing formatting
Looking at a column starting at the top and working down 1 cell at a time
first cell 1,2,4,3. second cell 2,4,3,1 third cell 4,3,1,2 Forth cell 3,1,2,4 Thanks "Stefi" wrote: Do you mean that a single cell should contain either 1,2,4,3 or 2,4,3,1 or 4,3,1,2 or 3,1,2,4? Stefi €˛Jim M€¯ ezt Ć*rta: I am using MS Excel and want to have 4 sets of numbers only be available in the cells I pick. The numbers and sequence of these numbers are first set. 1,2,4,3. Second set 2,4,3,1.Third set 4,3,1,2. four 3,1,2,4. Thanks Jim |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel number sequencing formatting
Sorry Jim, but I still don't know what do you want to achieve! You can enter
these four sets manually in the first four cells of a column, say column A, thus you have A 1 1,2,4,3 2 2,4,3,1 3 4,3,1,2 4 3,1,2,4 And what to do now? Stefi €˛Jim M€¯ ezt Ć*rta: Looking at a column starting at the top and working down 1 cell at a time first cell 1,2,4,3. second cell 2,4,3,1 third cell 4,3,1,2 Forth cell 3,1,2,4 Thanks "Stefi" wrote: Do you mean that a single cell should contain either 1,2,4,3 or 2,4,3,1 or 4,3,1,2 or 3,1,2,4? Stefi €˛Jim M€¯ ezt Ć*rta: I am using MS Excel and want to have 4 sets of numbers only be available in the cells I pick. The numbers and sequence of these numbers are first set. 1,2,4,3. Second set 2,4,3,1.Third set 4,3,1,2. four 3,1,2,4. Thanks Jim |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel number sequencing formatting
Yes
"Stefi" wrote: Do you mean that a single cell should contain either 1,2,4,3 or 2,4,3,1 or 4,3,1,2 or 3,1,2,4? Stefi €˛Jim M€¯ ezt Ć*rta: I am using MS Excel and want to have 4 sets of numbers only be available in the cells I pick. The numbers and sequence of these numbers are first set. 1,2,4,3. Second set 2,4,3,1.Third set 4,3,1,2. four 3,1,2,4. Thanks Jim |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel number sequencing formatting
Stefi
I just want to make sure I don't run any sequence other than the set i noted above. Each set of number will have it's own cell. Let say I try adding sequence 1,2,3,4 I would like to have the Exel block any cells that I would chose from putting a different sequence other than the sequence note. Thanks Jim "Jim M" wrote: Yes "Stefi" wrote: Do you mean that a single cell should contain either 1,2,4,3 or 2,4,3,1 or 4,3,1,2 or 3,1,2,4? Stefi €˛Jim M€¯ ezt Ć*rta: I am using MS Excel and want to have 4 sets of numbers only be available in the cells I pick. The numbers and sequence of these numbers are first set. 1,2,4,3. Second set 2,4,3,1.Third set 4,3,1,2. four 3,1,2,4. Thanks Jim |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel number sequencing formatting
1 2 4 3
2 4 3 1 4 3 1 2 3 1 2 4 "Jim M" wrote: Stefi I just want to make sure I don't run any sequence other than the set i noted above. Each set of number will have it's own cell. Let say I try adding sequence 1,2,3,4 I would like to have the Exel block any cells that I would chose from putting a different sequence other than the sequence note. Thanks Jim "Jim M" wrote: Yes "Stefi" wrote: Do you mean that a single cell should contain either 1,2,4,3 or 2,4,3,1 or 4,3,1,2 or 3,1,2,4? Stefi €˛Jim M€¯ ezt Ć*rta: I am using MS Excel and want to have 4 sets of numbers only be available in the cells I pick. The numbers and sequence of these numbers are first set. 1,2,4,3. Second set 2,4,3,1.Third set 4,3,1,2. four 3,1,2,4. Thanks Jim |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel number sequencing formatting
Well, I'm still not sure, but if you have the table below in range A1:D4 then
enter this formula in E1: =A1&","&B1&","&C1&","&D1 select range F1:F4 and DataValidationChoose Custom validation from drop down list and enter =E1=F1 in formula field. Cell F1 accepts only 1,2,4,3 etc. Stefi €˛Jim M€¯ ezt Ć*rta: 1 2 4 3 2 4 3 1 4 3 1 2 3 1 2 4 "Jim M" wrote: Stefi I just want to make sure I don't run any sequence other than the set i noted above. Each set of number will have it's own cell. Let say I try adding sequence 1,2,3,4 I would like to have the Exel block any cells that I would chose from putting a different sequence other than the sequence note. Thanks Jim "Jim M" wrote: Yes "Stefi" wrote: Do you mean that a single cell should contain either 1,2,4,3 or 2,4,3,1 or 4,3,1,2 or 3,1,2,4? Stefi €˛Jim M€¯ ezt Ć*rta: I am using MS Excel and want to have 4 sets of numbers only be available in the cells I pick. The numbers and sequence of these numbers are first set. 1,2,4,3. Second set 2,4,3,1.Third set 4,3,1,2. four 3,1,2,4. Thanks Jim |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel number sequencing formatting
Stefi,
Im a beginner and sorry to say I need everything spelled out as basic as it can be for me. Example click on cell E1 type in A1,B1,C1,D1 and if comas cant be used please let me know what to put in the cell and how it has to be written. Thank you for you time and patiences Jim M "Jim M" wrote: I am using MS Excel and want to have 4 sets of numbers only be available in the cells I pick. The numbers and sequence of these numbers are first set. 1,2,4,3. Second set 2,4,3,1.Third set 4,3,1,2. four 3,1,2,4. Thanks Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatic number sequencing? | Excel Worksheet Functions | |||
| Sequencing of projects | Excel Discussion (Misc queries) | |||
| Row Sequencing | Excel Worksheet Functions | |||
| Formula for Sequencing Totals | Excel Worksheet Functions | |||
| Alphabet sequencing in a conditional format | Excel Discussion (Misc queries) | |||
![Jim M[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
