Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding min values address and getting value from same column
ok here is what i have.
A B C D E 1 V W X Y 2 1.95 1.55 1.75 2.05 #Display now in cell E2 i want it to find the minimum value from A2 to D2 and display the letter above that minimum values column found in row 1 (V,W,X or Y). so in this example i want W to be displayed in Cell E2. thank you, Jonathan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding min values address and getting value from same column
This should do the trick: Sub test() Dim rng As Range Worksheets("Sheet1").Range("A2:D2").Select Set rng = Selection.Find(What:=Application.min(Selection) Lookat:=xlWhole, LookIn:=xlValues) Range("E2") = rng.Offset(-1, 0) End Sub Alseikha -- Alseikha ----------------------------------------------------------------------- Alseikhan's Profile: http://www.excelforum.com/member.php...fo&userid=3236 View this thread: http://www.excelforum.com/showthread.php?threadid=52502 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding multiple non-zero values in a column | Excel Worksheet Functions | |||
finding multiple non-zero values in a column | Excel Worksheet Functions | |||
Finding missing values in a column | Excel Worksheet Functions | |||
Finding the first and last column with values | Excel Discussion (Misc queries) | |||
Finding the max of a column where values less than a specified number | Excel Worksheet Functions |