Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Set Textbox value = large(ARRAY,k)
Hello,
MS EXCEL 2003 on XP PRO. I recently discovered I could set a text box equal to a cell and I tried to extrapolated that ability to use the LARGE formula and it wouldn't let me. What I'd like to do is basically have a textbox display the result of "=large($A1:$A4,1)" without having to type the values in. (I am creating a template) Any ideas? Note, doing just what I typed above did not work. It didn't recognize large. NOTE:::: I cannot use MAX() because I want to have multiple text boxes each with it's own ranking. (one for largest, one for 2nd largest, etc) Thanks. -- BlueWolverine MSE - Mech. Eng. Go BLUE! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Set Textbox value = large(ARRAY,k)
SOLVED IT.
I setup a small table to evaluate =large(ARRAY,K) and then pointed a text box directly at the #k spot. Thx anyway. -- BlueWolverine MSE - Mech. Eng. Go BLUE! "BlueWolverine" wrote: Hello, MS EXCEL 2003 on XP PRO. I recently discovered I could set a text box equal to a cell and I tried to extrapolated that ability to use the LARGE formula and it wouldn't let me. What I'd like to do is basically have a textbox display the result of "=large($A1:$A4,1)" without having to type the values in. (I am creating a template) Any ideas? Note, doing just what I typed above did not work. It didn't recognize large. NOTE:::: I cannot use MAX() because I want to have multiple text boxes each with it's own ranking. (one for largest, one for 2nd largest, etc) Thanks. -- BlueWolverine MSE - Mech. Eng. Go BLUE! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Large array, slow calcualtion of formulas | Excel Discussion (Misc queries) | |||
large function in non-continguous array? | Excel Discussion (Misc queries) | |||
Calculating Median Value in a large array | Excel Discussion (Misc queries) | |||
How do I paste horizontal references in large array | Excel Worksheet Functions | |||
Textbox disappears in large chart-Excel bug? | Excel Discussion (Misc queries) |