Array Formula Minimum Excluding Text
"Adams SC" wrote:
I have a group # in column A. In column G, for each group, I want to take
value in column F - Less the minimum for group. I can get this far, in some
cases I don't have a value in column F, I have a text entry. I want those
entries ignored for the minimum calculation.
More Information
Columns
A D E F G
1 0.58 -0.006 0.574 0.006
1 0.62 -0.006 0.614 0.046
1 0.59 -0.022 0.568 -
1 0.61 -0.006 0.604 -
2 0.57 -0.006 0.564 -
2 0.58 -0.006 0.574 0.006
2 0.59 -0.022 0.568 -
2 0.61 -0.006 0.604 -
3 0.645 -0.023 0.622 -
3 Price n/a Price n/a Price n/a #VALUE!
3 0.64 -0.006 0.634 -
Formula in G currently is =F2-MIN(IF(A2:A47=Table3[[#This
Row],[Group]],F2:F47))
|