| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 |
|
#2
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 |
|
#3
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 |
|
#4
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 |
| 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)
Hybrid Mode
