Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Query
I need assistance with a simple excel formula, with which i have been
struggling. the file I am working a has column that has data from another sheet(using vlookup). I have to use this data again to find the lowest score is. I use Mi() to find the lowest score. However, as the cell contains a formula, the min calculates any empty lookup as a 0, thereby, automatically using this as the lowest entry. Could we arrange a formula that ignores any entries that are 0 in a range of cell. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Query
Hi PD,
Try a formula of the type: =MIN(IF(E6:E11<0,E6:E11)) This is an array formula which should be confirmed with Shift-Ctrl-Enter instead of Enter. --- Regards. Norman "PD" wrote in message ... I need assistance with a simple excel formula, with which i have been struggling. the file I am working a has column that has data from another sheet(using vlookup). I have to use this data again to find the lowest score is. I use Mi() to find the lowest score. However, as the cell contains a formula, the min calculates any empty lookup as a 0, thereby, automatically using this as the lowest entry. Could we arrange a formula that ignores any entries that are 0 in a range of cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Edit Query from Excel will not open query in MSQuery | Excel Programming | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |