Excel number sequencing formatting

[Jim M]

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

 

[Stefi]

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:

 

[Jim M]

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]

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:

 

[Jim M]

Yes

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:

 

[Jim M]

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]

1 2 4 3
2 4 3 1
4 3 1 2
3 1 2 4

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

 

[Stefi]

Well, I'm still not sure, but if you have the table below in range A14 then
enter this formula in E1:
=A1&","&B1&","&C1&","&D1
select range F1:F4 and Data>Validation>Choose 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:

 

[Jim M]

Stefi,
I’m 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
can’t 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 patience’s
Jim M