+ Reply to Thread
Results 1 to 3 of 3

Count the Maximum contribution factor for every vendor

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

    Count the Maximum contribution factor for every vendor

    Hi All,

    Hope you are doing well!.. I am trying to get the maximum count of the contribution factors for every vendor.. And I am trying to search for the words -Promotion,Availability,BuyBox in the contribution column and identify the one with the maximum count for every vendor ..The contribution field has multiple text along with the words Promotion,Availability,BuyBox which is the challenge that i am facing ...Please find attached the excel file with the expected output..Can you pls help with the same...

    Thanks,
    Arun
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Count the Maximum contribution factor for every vendor

    Try these array formulas, in F2
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and G2
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    With a list of the words to search for in $K$1:$K$4. Note that if you copy and paste the words from your sample, there is a stray space at the end of 'Availability ' which needs to be removed of the second formula will fail.

    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

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

    Re: Count the Maximum contribution factor for every vendor

    Hi Jason,

    This is awesome!!!!...Really appreciate your help!!!...

    Thanks,
    Arun

+ 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. Maximum count at any given time
    By jeex87 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-01-2019, 03:19 AM
  2. formula to know count the vendor wise ontime & late
    By vinayvanam in forum Excel General
    Replies: 7
    Last Post: 12-26-2017, 02:10 AM
  3. Replies: 4
    Last Post: 04-24-2017, 09:13 AM
  4. [SOLVED] Factor Up and Factor Down Values Formula
    By alive555 in forum Excel General
    Replies: 6
    Last Post: 08-14-2015, 12:01 PM
  5. Replies: 11
    Last Post: 01-04-2014, 12:12 AM
  6. Count # of style in a range of Sale % Contribution
    By goicuon in forum Excel General
    Replies: 19
    Last Post: 06-12-2012, 05:27 PM
  7. [SOLVED] Maximum Row Count
    By Mike Labosh in forum Excel General
    Replies: 4
    Last Post: 01-04-2005, 01:06 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