Dubble numbers

[bullit_nl]

Hi,

I have posted about this subject before but the post got lost (2002-30-09).

I have a sheet where i use validation to prevent myself (and others) to use the same numbers. This works fine.

Now i also wanna make sure that the numbers i type always must contain 8 numbers.

Ex. 90090001 and not 9009001.

I know this also can be done with validation. But is it possible to have it both?

Thanks
This message was edited by bullit_nl on 2002-10-04 05:30
This message was edited by bullit_nl on 2002-10-04 05:31

 

[Aladin Akyurek]

On 2002-10-04 05:29, bullit_nl wrote:
Hi,

I have posted about this subject before but the post got lost (2002-30-09).

I have a sheet where i use validation to prevent myself (and others) to use the same numbers. This works fine.

Now i also wanna make sure that the numbers i type always must contain 8 numbers.

Ex. 90090001 and not 9009001.

I know this also can be done with validation. But is it possible to have it both?

Thanks
This message was edited by bullit_nl on 2002-10-04 05:30
This message was edited by bullit_nl on 2002-10-04 05:31

Expand the formula that you use...

=AND(...,LEN(Cell)=8)

 

[bullit_nl]

On 2002-10-04 05:56, Aladin Akyurek wrote:

On 2002-10-04 05:29, bullit_nl wrote:
Hi,

I have posted about this subject before but the post got lost (2002-30-09).

I have a sheet where i use validation to prevent myself (and others) to use the same numbers. This works fine.

Now i also wanna make sure that the numbers i type always must contain 8 numbers.

Ex. 90090001 and not 9009001.

I know this also can be done with validation. But is it possible to have it both?

Thanks
This message was edited by bullit_nl on 2002-10-04 05:30
This message was edited by bullit_nl on 2002-10-04 05:31

Expand the formula that you use...

=AND(...,LEN(Cell)=8)

Hi Aladin,

The formula is use now is:

=AANTAL.ALS($B$3:$K$100;E46)=1

Where (how) should i expand the formula?

Thanks

 

[Aladin Akyurek]

Hi Aladin,

The formula is use now is:

=AANTAL.ALS($B$3:$K$100;E46)=1

Where (how) should i expand the formula?

I assume the formula wrt B3 will look as

=AANTAL.ALS($B$3:$K$100;B3)=1

If so, select B3:K100, activate Data|Validation and change the formula to:

=EN(AANTAL.ALS($B$3:$K$100;B3)=1,LENGTE(B3)=8)

 

[bullit_nl]

It works perfect.

Thanks Aladin

 

[bullit_nl]

On 2002-10-04 08:11, bullit_nl wrote:
It works perfect.

Thanks Aladin

Is it also possible with this formula to check for the dubble numbers on more sheets in one workbook?