+ Reply to Thread
Results 1 to 4 of 4

Alternate to Max Formula

  1. #1
    Forum Contributor
    Join Date
    12-11-2014
    Location
    dubai
    MS-Off Ver
    2010
    Posts
    142

    Alternate to Max Formula

    i need to use large formula with multiple criterias like LARGE((J9+K9*J8,M9+N9*M8),1) but it returns error.
    I know same can be used within Max function but its slowing down my workbook as it has lot of criterias.
    What could be the correct format to use the above criterias within large function.

    Thanks

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Alternate to Max Formula

    try it like this

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Forum Contributor
    Join Date
    12-11-2014
    Location
    dubai
    MS-Off Ver
    2010
    Posts
    142

    Re: Alternate to Max Formula

    Thanks Vlady, appreciate your help cheers!

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Alternate to Max Formula

    Your very much welcome.

+ 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. Formula to count cells with dates based on criteria
    By suneeshpillai in forum Excel General
    Replies: 1
    Last Post: 03-17-2017, 08:21 AM
  2. Alternate Row Shading - conditional formula not working
    By iyoossaev in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-06-2013, 06:32 PM
  3. [SOLVED] Alternate formula for VLOOKUP in reporting.
    By luccallens in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-05-2013, 12:38 PM
  4. [SOLVED] Formula to show alternate weekly team.
    By Ortz in forum Excel General
    Replies: 3
    Last Post: 07-17-2012, 07:02 PM
  5. Formula: Alternate cell values
    By ugsquish in forum Excel General
    Replies: 2
    Last Post: 09-09-2011, 04:41 PM
  6. Alternate formula for CHAR formua in excle
    By aravindhan_31 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-23-2010, 04:16 AM
  7. Alternate Vlookup formula
    By mangesh in forum Excel General
    Replies: 3
    Last Post: 07-23-2010, 02:40 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