+ Reply to Thread
Results 1 to 7 of 7

Find the maximum and minimum values

  1. #1
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 2007
    Posts
    167

    Find the maximum and minimum values

    MAX
    D2 = "TV" including Color TV,Black and white TV,34 inch TV, pls write a formula to find Max value(Write the found value to CELL E2)
    D3 = "washing machine" including washing machine,Vegetable washing machine,Premium washing machine . pls write a formula to find Max value(Write the found value to CELL E3)

    Min
    D2 = "TV" including Color TV,Black and white TV,34 inch TV, pls write a formula to find Min value(Write the found value to CELL F2)
    D3 = "washing machine" including washing machine,Vegetable washing machine,Premium washing machine . pls write a formula to find Min value(Write the found value to CELL F3)


    Thanks for any help !
    Attached Files Attached Files
    Last edited by rayhen; 05-29-2021 at 08:19 AM.

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,627

    Re: Find the maximum and minimum values

    Pl see file. ARRAY formulas are used.
    In E2

    =MAX(IF(ISNUMBER(SEARCH($D2,$A$2:$A$11)),$B$2:$B$11,""))

    In F2

    =MIN(IF(ISNUMBER(SEARCH($D2,$A$2:$A$11)),$B$2:$B$11,""))

    To enter ARRAY formula
    Copy and paste the formula in cell
    Press F2
    Press Ctrl+Shift+Enter together
    Excel covers the formula with {}.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 2007
    Posts
    167

    Re: Find the maximum and minimum values

    Outstanding solution. Thanks a lot for the proposed solution tq

  4. #4
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,497

    Re: Find the maximum and minimum values

    Select the cell area E2:F2 , array formula, copy this cell area E2:F2 and drag it down

    HTML Code: 

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,627

    Re: Find the maximum and minimum values

    Thanks for feed back and rep.

  6. #6
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 2007
    Posts
    167

    Re: Find the maximum and minimum values

    @wk9128, thank you again, you are awesome

  7. #7
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,497

    Re: Find the maximum and minimum values

    You're Welcome. Thank You for the feedback , Glad to help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 12-04-2019, 11:20 AM
  2. Replies: 3
    Last Post: 07-23-2016, 07:49 AM
  3. [SOLVED] Find Minimum or Maximum with Multiple Criteria Not Working
    By mycon73 in forum Excel General
    Replies: 3
    Last Post: 04-24-2016, 11:45 PM
  4. minimum value out of maximum values
    By shamym in forum Excel General
    Replies: 9
    Last Post: 01-21-2015, 05:42 AM
  5. Find maximum and minimum value for each date
    By anna.gladkova in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-05-2012, 08:50 PM
  6. How do I find the cell reference that contains the minimum or maximum
    By fadsnet in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2006, 11:55 PM

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