Thread
:
Array Formula Minimum Excluding Text
View Single Post
#
3
Posted to microsoft.public.excel.misc
Ron Rosenfeld
external usenet poster
Posts: 5,651
Array Formula Minimum Excluding Text
On Wed, 7 Mar 2007 13:01:10 -0800, Adams SC <Adams
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.
If you enter the argument as a range, MIN will ignore text
--ron
Reply With Quote
Ron Rosenfeld
View Public Profile
Find all posts by Ron Rosenfeld