Data validation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter - 07 Apr 2004 18:36 GMT

I have a workbook to record employees mileage in company vehicles.
I have validated the mileage so that it is greater than the previous days,
but not greater than a later value.

Cell D19

Allow: Whole Number

Data: between

Minimum: =MAX($D$16:D18)

Maximum: =IF(MIN(D20:$D$47)>0,MIN(D20:$D$47),"")

The cell values sometimes corrupt to 6 figure numbers thus acusing the cell
to reject the data inputted by the user.

i.e.

Cell D19

Allow: Whole Number

Data: between

Minimum: =MAX($D$16:D568418)

Maximum: =IF(MIN(D20:$D$568418)>0,MIN(D20:$D$568418),"")

Does anyone know why this happens and how to prevent it?

Peter

Reply to this Message

Dave Hawley - 08 Apr 2004 02:51 GMT

Hi Peter

Your question is unclear, for example, what does;

"The cell values sometimes corrupt to 6 figure numbers thus acusing the
cell
to reject the data inputted by the user"

mean?

Reply to this Message

Bruce Sinclair - 08 Apr 2004 04:13 GMT

>Hi Peter
>
[quoted text clipped - 5 lines]
>
>mean?

This was clear to me from the examples. Means the cell reference
"corrupts" (eg was $D$47 to $D$505212 or something similar).

Bruce

-----------------------------------------------------------------------
It was so much easier to blame it on Them. It was bleakly depressing to
think that They were Us. If it was Them, then nothing was anyone?s fault.
If it was Us, what did that make Me ? After all, I?m one of Us. I must be.
I?ve certainly never thought of myself as one of Them. No-one ever thinks
of themselves as one of Them. We?re always one of Us. It?s Them that do
the bad things. <=> Terry Pratchett. Jingo.

Reply to this Message

Dave Hawley - 08 Apr 2004 06:49 GMT

So help him out then.

Reply to this Message

Peter - 08 Apr 2004 21:26 GMT

Sorry about the Typo, (acusing should be causing).
Dave got the gist.
Anyone any ideas please?

> Hi Peter
>
[quoted text clipped - 9 lines]
> Excel Templates, Training & Add-ins.
> Free Excel Forum http://www.ozgrid.com/forum *****

Reply to this Message