Hi,

Not sure I understand but perhaps something like this:

=IF(ISTEXT(F1),"",F1-MIN(IF($A$1:$A$10=A1,$F$1:$F$10)))
enter using Ctrl+Shift+Enter then copy down

HTH
Jean-Guy

"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.