Home |
Search |
Today's Posts |
#1
|
|||
|
|||
min function from different columns
hi! I need some help again! I have a sheet setup like this.
a b 1 x 41 2 y 30 3 x 45 4 y 43 5 x 37 6 y 29 I am using the function =MIN(IF(a1:a6="x",b1:b6)) then C+S+E this keeps returning zero How can I correct this formula to actually return the minimum for x instead of zero Thanks in advance. Derek |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
analysing data from alternate columns using the countif function | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Sumif function with two criteria from different columns | Excel Worksheet Functions | |||
MATCH function - 2 columns w/ SIMILAR, not EXACT data | Excel Worksheet Functions | |||
How do I perform a "Countif" function for Two Columns? | Excel Worksheet Functions |