Data validation

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

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
 
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?
Click to expand...

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.
 
Sorry about the Typo, (acusing should be causing).
Dave got the gist.
Anyone any ideas please?
 
Back
Top