Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional display
I have a worksheet wherein there's a cell that displays the "minimum" number
from a group of five [or more] numbers; each of those five [or more] numbers is associated with a "text statement". Is there a formula I can employ, that would allow me to display, in a cell, the "text statement" associated with the minimum number? My goal is to be able to automatically display [based on which number is the minimum] the associated text statement. Thus the reader of the worksheet will see displayed the text statement associated with the appropriate minimum number. Thanks! -- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional display
One way ..
Assuming text within A1:A5, numbers within B1:B5 placed in say, C1: =INDEX(A1:A5,MATCH(MIN(B1:B5),B1:B5,0)) will return the text corresponding to the minimum of the numbers Should there be a tie(s) in the min numbers, it'll return the first match, ie the text which is "higher up" within A1:A5 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Shadowman13" wrote: I have a worksheet wherein there's a cell that displays the "minimum" number from a group of five [or more] numbers; each of those five [or more] numbers is associated with a "text statement". Is there a formula I can employ, that would allow me to display, in a cell, the "text statement" associated with the minimum number? My goal is to be able to automatically display [based on which number is the minimum] the associated text statement. Thus the reader of the worksheet will see displayed the text statement associated with the appropriate minimum number. Thanks! -- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional display
I read this slightly different than Max.
I thought that the cell already had the minimum value in it. If that's the case, I'd create a new worksheet and create a table. Column A would hold the numbers and column B would hold the text. and use a formula like (with A1 holding the minimum value): =if(a1="","",vlookup(a1,sheet2!a:b,2,false)) Shadowman13 wrote: I have a worksheet wherein there's a cell that displays the "minimum" number from a group of five [or more] numbers; each of those five [or more] numbers is associated with a "text statement". Is there a formula I can employ, that would allow me to display, in a cell, the "text statement" associated with the minimum number? My goal is to be able to automatically display [based on which number is the minimum] the associated text statement. Thus the reader of the worksheet will see displayed the text statement associated with the appropriate minimum number. Thanks! -- -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional display
That worked extremely well. Thanks so much for the quick response.
-- Steve "Max" wrote: One way .. Assuming text within A1:A5, numbers within B1:B5 placed in say, C1: =INDEX(A1:A5,MATCH(MIN(B1:B5),B1:B5,0)) will return the text corresponding to the minimum of the numbers Should there be a tie(s) in the min numbers, it'll return the first match, ie the text which is "higher up" within A1:A5 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Shadowman13" wrote: I have a worksheet wherein there's a cell that displays the "minimum" number from a group of five [or more] numbers; each of those five [or more] numbers is associated with a "text statement". Is there a formula I can employ, that would allow me to display, in a cell, the "text statement" associated with the minimum number? My goal is to be able to automatically display [based on which number is the minimum] the associated text statement. Thus the reader of the worksheet will see displayed the text statement associated with the appropriate minimum number. Thanks! -- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional display
welcome, good to hear it worked for you.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Shadowman13" wrote in message ... That worked extremely well. Thanks so much for the quick response. -- Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional display of certain rows | Setting up and Configuration of Excel | |||
How do I display all conditional formatting in Excel? | Excel Worksheet Functions | |||
Display conditional data | Excel Discussion (Misc queries) | |||
Conditional Display | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |