Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Update validated list wording? | Excel Worksheet Functions | |||
Call up worksheet based on validated list | Excel Discussion (Misc queries) | |||
Concatenate Results from a Validated Drop Down List | Excel Discussion (Misc queries) | |||
Unique Dynamic Validated List | Excel Worksheet Functions | |||
how do I resize the text in a validated list? | Excel Worksheet Functions |