+ Reply to Thread
Results 1 to 10 of 10

Prioritization of Items based on Flags and Sales potential

  1. #1
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Red face Prioritization of Items based on Flags and Sales potential

    Hi all,

    Hope you are doing well!...I am trying to prioritize SKU's based on the power by each vendor ....The higher the power higher the priority and also subsequent priorities should be unique even though the power is same within a vendor level...Also if the SKU has a flag that is equal to 1 then that SKU has to be prioritized only after the other SKU'S for that vendor has been prioritized...


    ...I have attached the workbook and highlighted the result required in yellow....Can you please help here...


    Thanks,
    Arun
    Last edited by chandramouliarun; 11-07-2019 at 07:54 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Prioritization of SKU'S based on Flags and Sales potential

    Hi
    what are SKU's please? Keep in mind not everyone understands your technical jargon. How clearer the title how faster you might get an answer...
    Thanks

  3. #3
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Re: Prioritization of SKU'S based on Flags and Sales potential

    Hi Pepe,

    Apologies for not clarifying my technical jargon!..SKU's imply items for sale online...

    Thanks,
    Arun

  4. #4
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Re: Prioritization of SKU'S based on Flags and Sales potential

    Seeking some help here!!

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Prioritization of Items based on Flags and Sales potential

    Administrative Note:

    We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it has been only 4 hours since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

  6. #6
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Re: Prioritization of Items based on Flags and Sales potential

    @Pepe!...Apologies !...Will make sure not to bump up the threads going forward...But if I am not getting help in this forum can I try other excel forums ..Will it be an issue of reposting....

  7. #7
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Prioritization of Items based on Flags and Sales potential

    No, as longs as you adhere to our cross-posting policy ( see forum rules)
    You can also try our Commercial Services for faster answers

  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,427

    Re: Prioritization of Items based on Flags and Sales potential

    This proposal employs two helper columns (F:G) which may be moved and/or hidden for aesthetic purposes.
    1. Paste the following into F2: =IF(ISNUMBER(D2),"",SUM(SUMPRODUCT((C$2:C$9>C2)*(B$2:B$9=B2)*(D$2:D$9="")),COUNTIFS(B$2:B2,B2,C$2:C2,C2)))
    2. Paste the following into G2: =IF(F2="",AGGREGATE(14,6,(F$2:F$9)/(B$2:B$9=B2),1)+1,"")
    3. Paste the following into E2: =SUM(F2,G2)
    4. Select E2:G2 and drag the fill handle down to G9
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  9. #9
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Re: Prioritization of Items based on Flags and Sales potential

    Thanks JeteMc!...Appreciate your help!...

    Thanks,
    Arun

  10. #10
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,427

    Re: Prioritization of Items based on Flags and Sales potential

    You're Welcome. If that resolves the issue, please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ 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. [SOLVED] Prioritizing SKU'S based on Power and Potential
    By chandramouliarun in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-04-2019, 02:23 AM
  2. Replies: 4
    Last Post: 01-16-2019, 12:35 PM
  3. [SOLVED] Formula for Case Rate Payment prioritization
    By Hodor84 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 08-04-2017, 12:28 PM
  4. [SOLVED] Vlookup to pull in sales data based on the month sales begins
    By adam_d_john in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 06-12-2017, 05:07 PM
  5. [SOLVED] Return unique values based on potential multiple conditions
    By C J W in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-29-2017, 10:14 AM
  6. Array function to allocate total across accounts based on prioritization
    By lpcapital in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-29-2013, 04:56 PM
  7. Prioritization countif function
    By culverhr in forum Excel General
    Replies: 3
    Last Post: 10-11-2011, 01:24 PM

Tags for this Thread

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