+ Reply to Thread
Results 1 to 6 of 6

Profit % Max to Min

  1. 02-12-2021, 05:32 PM #1
    rr1050
    rr1050 is offline
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    235

    Angry Profit % Max to Min

    Hi to All,

    I am looking for project name get in the "AH12" onwards as per the maximum profit % earned in the AK to AT first rows.

    Results in descending order in AH12.

    Thanks

    Regards, RR
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-12-2021, 10:31 PM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,213

    Re: Profit % Max to Min

    Please try

    =TRANSPOSE(FILTER(SORTBY(AK3:AT3,AK1:AT1,-1),AK1:AT1))
    Attached Files Attached Files
    Last edited by Bo_Ry; 02-13-2021 at 10:07 AM. Reason: corection
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  3. 02-13-2021, 02:49 AM #3
    rr1050
    rr1050 is offline
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    235

    Re: Profit % Max to Min

    The result is not matching what I have given in the file. The evaluation should be in descending order.

    Also, I am looking for a VBA solution, to learn more.
    Reply With QuoteRegister To Reply
  4. 02-13-2021, 03:29 AM #4
    nankw83
    nankw83 is offline
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,712

    Re: Profit % Max to Min

    Hi rr1050,

    One way based on your sample file ... 
    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name
    Reply With QuoteRegister To Reply
  5. 02-13-2021, 03:46 AM #5
    rr1050
    rr1050 is offline
    Forum Contributor
    Join Date
    12-27-2008
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    235

    Re: Profit % Max to Min

    Wow, it worked
    Many many thanks...
    Reply With QuoteRegister To Reply
  6. 02-13-2021, 03:50 AM #6
    nankw83
    nankw83 is offline
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,712

    Re: Profit % Max to Min

    Glad to help & we're welcome
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot table profit and loss by month - calculate gross profit and gross profit %
    By parkviewfinance in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-26-2020, 02:34 AM
  2. Count the profit with if statement
    By Mark-44 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-06-2018, 04:50 AM
  3. Formula Which Will Only Show A Positive Profit And Remain Blank When Negative Profit
    By WILDWOLF001 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2014, 01:46 PM
  4. Working with sales, profit, net income, profit margin & etc
    By Quintin in forum Excel General
    Replies: 0
    Last Post: 01-21-2014, 12:04 PM
  5. 1. consecutive days of profit and of losses 2. biggest profit loss since date
    By xbohemianx in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-14-2013, 12:57 PM
  6. Profit only if B2=33 and C2=18, please help
    By Jspearm in forum Excel General
    Replies: 1
    Last Post: 02-22-2006, 03:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1