Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find minimum non-blank value
Hi.
I have a statement which, for a given row, retrieves the value from column 2, of the form: x = Sheets("Sheet1").Cells(RowNum, 2) How do I rewrite this to retrieve the minimum non-blank value from columns 2 - 5? Thanks in advance for your help. ....Larry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find minimum non-blank value
Try this
x = WorksheetFunction.Min(Sheets("Sheet1").Columns(2)) Mike "lallen" wrote: Hi. I have a statement which, for a given row, retrieves the value from column 2, of the form: x = Sheets("Sheet1").Cells(RowNum, 2) How do I rewrite this to retrieve the minimum non-blank value from columns 2 - 5? Thanks in advance for your help. ...Larry |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
find minimum non-blank value
Thanks Mike. That wasn't exactly what I was looking for, but it pointed me in
the right direction. What worked for me was: x = WorksheetFunction.Min(Sheets("Sheet1").Range("B" & RowNum & ":E" & Rownum)) Thanks again for the quick response. ....Larry "Mike H" wrote: Try this x = WorksheetFunction.Min(Sheets("Sheet1").Columns(2)) Mike "lallen" wrote: Hi. I have a statement which, for a given row, retrieves the value from column 2, of the form: x = Sheets("Sheet1").Cells(RowNum, 2) How do I rewrite this to retrieve the minimum non-blank value from columns 2 - 5? Thanks in advance for your help. ...Larry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Minimum excluding blank cells | Excel Programming | |||
Find minimum value | Excel Worksheet Functions | |||
Find minimum value in column. | Excel Worksheet Functions | |||
Looking for faster way to find minimum value | Excel Programming | |||
Find minimum value greater than a particular value | Excel Worksheet Functions |