Configuring a cell to take higher values only
 

I have made an excel file in which I am writing cumulative
warranty report for my product. My subordinates are using this file and I
have made it as a shared document.

Now I want to avoid any chance of accidental wrong entry in any cell.

Is there any method whereby I can configure a cell so that it will take
only higher values than the existing entries in the cell.

--
Hemant N. Dhuri
Mumbai

Hi Hemant

What you can do is,
-select the area in which you want your subordinates to make entries.
-Click the menu Data--Validation
-Select settings then
--under allow select whole number,
--under data select greater than or equal to (you can work with this if you
want to change the conditions)
--select minimum(or maximum- it will change as the case is) type a number
you have set the limit for.
click OK

FIRST TEST AT YOUR END, it should work.
--
vijard


"hdhuri40" wrote:

I have made an excel file in which I am writing cumulative
warranty report for my product. My subordinates are using this file and I
have made it as a shared document.

Now I want to avoid any chance of accidental wrong entry in any cell.

Is there any method whereby I can configure a cell so that it will take
only higher values than the existing entries in the cell.

--
Hemant N. Dhuri
Mumbai

I didn't mean this type of data validation. It will give me rigidity
that I will be able to add only above particular no.I want to be made it in a
dynamic way.
Assuming a particular cell has entry 10 then next time if I want
to add 3 & make it 13 it should not beome 1 accidently. Again if I want to
add 10 & make it 23 it should not become 2 or 3 or the like.
--
Hemant N. Dhuri
Mumbai


"vijay" wrote:

Hi Hemant

What you can do is,
-select the area in which you want your subordinates to make entries.
-Click the menu Data--Validation
-Select settings then
--under allow select whole number,
--under data select greater than or equal to (you can work with this if you
want to change the conditions)
--select minimum(or maximum- it will change as the case is) type a number
you have set the limit for.
click OK

FIRST TEST AT YOUR END, it should work.
--
vijard


"hdhuri40" wrote:

I have made an excel file in which I am writing cumulative
warranty report for my product. My subordinates are using this file and I
have made it as a shared document.

Now I want to avoid any chance of accidental wrong entry in any cell.

Is there any method whereby I can configure a cell so that it will take
only higher values than the existing entries in the cell.

--
Hemant N. Dhuri
Mumbai

hdhuri40 wrote:
I didn't mean this type of data validation. It will give me rigidity

that I will be able to add only above particular no.I want to be made
it in a
dynamic way.
Assuming a particular cell has entry 10 then next time if
I want
to add 3 & make it 13 it should not beome 1 accidently. Again if I
want to
add 10 & make it 23 it should not become 2 or 3 or the like.
--
Hemant N. Dhuri
Mumbai


"vijay" wrote:

Hi Hemant

What you can do is,
-select the area in which you want your subordinates to make
entries.
-Click the menu Data--Validation
-Select settings then
--under allow select whole number,
--under data select greater than or equal to (you can work with
this if you
want to change the conditions)
--select minimum(or maximum- it will change as the case is) type a
number
you have set the limit for.
click OK

FIRST TEST AT YOUR END, it should work.
--
vijard


"hdhuri40" wrote:

I have made an excel file in which I am writing
cumulative
warranty report for my product. My subordinates are using this
file and I
have made it as a shared document.

Now I want to avoid any chance of accidental wrong entry in any
cell.

Is there any method whereby I can configure a cell so that it
will take
only higher values than the existing entries in the cell.

--
Hemant N. Dhuri
Mumbai

Hi!

If you duplicate the cell A1 elsewhere (=A1), you can check (data
validation using Number) with min set as the stored value and max set
as something arbitrarily big.
The stored value will update itself, ratchetting upwards only.

Alf

Hi,
This is also not dynamic.
I meant to say whether I can give circular references in excel
sheet so that the cells in itself will take higher value than original.
--
Hemant N. Dhuri
Mumbai


"AlfD" wrote:

Hi!

If you duplicate the cell A1 elsewhere (=A1), you can check (data
validation using Number) with min set as the stored value and max set
as something arbitrarily big.
The stored value will update itself, ratchetting upwards only.

Alf