Max value in validated list
 

I have a cell with a list of numbers used for validation in a drop down box.
Is there any way to retrieve the max possible value of that cell? For
example, if the choices in the dropdown are 0 - 15, how do I return the 15 so
I can use it in a function?

Max value in validated list
 

You'd have to list the numbers in a range of cells and then refer to that
range in a formula.

Say A1:A16 is your list of numbers from 0 to 15.
You can use the range A1:A16 as the source for the drop down list.
Then, to get the max value from that range:

=MAX(A1:A6)

Biff

"Erin" wrote in message
...
I have a cell with a list of numbers used for validation in a drop down
box.
Is there any way to retrieve the max possible value of that cell? For
example, if the choices in the dropdown are 0 - 15, how do I return the 15
so
I can use it in a function?

Max value in validated list
 

Typo:

Then, to get the max value from that range:
=MAX(A1:A6)

Should be:

=MAX(A1:A16)

Biff

"T. Valko" wrote in message
...
You'd have to list the numbers in a range of cells and then refer to that
range in a formula.

Say A1:A16 is your list of numbers from 0 to 15.
You can use the range A1:A16 as the source for the drop down list.
Then, to get the max value from that range:

=MAX(A1:A6)

Biff

"Erin" wrote in message
...
I have a cell with a list of numbers used for validation in a drop down
box.
Is there any way to retrieve the max possible value of that cell? For
example, if the choices in the dropdown are 0 - 15, how do I return the
15 so
I can use it in a function?

Max value in validated list
 

Thanks!

"T. Valko" wrote:

You'd have to list the numbers in a range of cells and then refer to that
range in a formula.

Say A1:A16 is your list of numbers from 0 to 15.
You can use the range A1:A16 as the source for the drop down list.
Then, to get the max value from that range:

=MAX(A1:A6)

Biff

"Erin" wrote in message
...
I have a cell with a list of numbers used for validation in a drop down
box.
Is there any way to retrieve the max possible value of that cell? For
example, if the choices in the dropdown are 0 - 15, how do I return the 15
so
I can use it in a function?

Max value in validated list
 

You're welcome!

Biff

"Erin" wrote in message
...
Thanks!

"T. Valko" wrote:

You'd have to list the numbers in a range of cells and then refer to that
range in a formula.

Say A1:A16 is your list of numbers from 0 to 15.
You can use the range A1:A16 as the source for the drop down list.
Then, to get the max value from that range:

=MAX(A1:A6)

Biff

"Erin" wrote in message
...
I have a cell with a list of numbers used for validation in a drop down
box.
Is there any way to retrieve the max possible value of that cell? For
example, if the choices in the dropdown are 0 - 15, how do I return the
15
so
I can use it in a function?