Results 1 to 8 of 8

Return Maximum value with Conditions

Threaded View

Ore4444 Return Maximum value with... 07-06-2011, 01:19 AM
Azam Ali Re: Return Maximum value with... 07-06-2011, 07:38 AM
zbor Re: Return Maximum value with... 07-06-2011, 07:48 AM
canapone Re: Return Maximum value with... 07-06-2011, 07:51 AM
Azam Ali Re: Return Maximum value with... 07-07-2011, 12:41 AM
Haseeb Avarakkan Re: Return Maximum value with... 07-07-2011, 02:13 AM
Haseeb Avarakkan Re: Return Maximum value with... 07-07-2011, 02:17 AM
canapone Re: Return Maximum value with... 07-07-2011, 02:22 AM
  1. #1
    Registered User
    Join Date
    04-06-2011
    Location
    Kibbutz Lotan, Israel
    MS-Off Ver
    Office 2010
    Posts
    1

    Question Return Maximum value with Conditions

    Hi guys.
    I really hope you could help me with this one.

    My table is:
    A B
    0.71 1
    0.26 0
    1.11 0
    1.11 1
    7.63 1
    0.19 0
    0.16 0
    3.00 1
    0.17 0
    0.17 0
    0.17 0
    0.17 0
    1.24 1
    1.68 2
    2.54 2
    1.01 2
    1.65 2
    2.11 2
    1.01 2
    1.85 2
    2.45 2
    2.07 2

    So I have the A column tat consists of, let's say, electricity consumption of a house and the B column that consists of, say, the number of occupants in the house.

    Now, I want to use the MIN & MAX functions on the A column to get, respectively, the MAXimum value from the A column and the MINimum value from the A column.

    But, now comes the tricky part. I want to do so with excluding the cells that have the number 0 next to them in column B.

    In other words, I need a function that'll tell Excel: "Find the MAX & MIN values from range A1:A20. Put into the calculation only the cells in the range that have a number larger than zero in the cell directly to their right."

    Of course, my actual project is in a much larger scale.

    BTW, I use Excel 2010.

    Thank you very much
    Last edited by Ore4444; 07-06-2011 at 02:55 AM. Reason: Title change

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1