+ Reply to Thread
Results 1 to 5 of 5

Same bid vendor

  1. 12-12-2015, 04:45 PM #1
    SusanWi
    SusanWi is offline
    Registered User
    Join Date
    12-05-2015
    Location
    Auckland, New Zealand
    MS-Off Ver
    Mac 11
    Posts
    21

    Same bid vendor

    HI - I must say this is a great place to get expert help in Excel - Could I please have advise or help with this problem?

    I have attached test spread sheet against which I am asking the questions below


    1. Is there a best formula (easy to understand) that identifies the same price vendor ? (number of ties ?)
    2. How do I work out how a formula identifying same bid supplier ? (formula ?) ?)
    3. Under heading above 'price break' I used conditional formatting (entered =min(if(D4:F4>0,D4:F4)) then control shift return on my mac)
    But highlights all 3 values under price break 2
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-12-2015, 05:43 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Same bid vendor

    Hi, welcome to the forum

    1. Did you try just =MIN(A3:C3) ...This should also ignore blank entries, and I doubt you would have a bid of 0? So...
    I3=MIN(A3:C3)
    2. When multiplying, you dont need SUM, so
    J3=I3*G3
    3. for the count...
    K3=COUNTIF(A3:C3,I3)
    4. To ID the lowest bid...
    L3=INDEX($A$2:$C$2,MATCH(I4,A4:C4,0))
    5. To find the other matches...
    M3=IFERROR(INDEX($A$2:$C$2,SMALL(IF($A$3:$C$3=$I3,COLUMN($A$3:$C$3)),COLUMNS($A$1:B1))),"")
    ARRAY entered (using CTRL SHFT ENTER, not just ENTER

    Not sure where you got 3 ties for row 2?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 12-12-2015, 07:07 PM #3
    SusanWi
    SusanWi is offline
    Registered User
    Join Date
    12-05-2015
    Location
    Auckland, New Zealand
    MS-Off Ver
    Mac 11
    Posts
    21

    Re: Same bid vendor

    thank you for your help
    Reply With QuoteRegister To Reply
  4. 12-12-2015, 07:09 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Same bid vendor

    wow, did that answer all your questions?
    Reply With QuoteRegister To Reply
  5. 12-13-2015, 01:26 AM #5
    SusanWi
    SusanWi is offline
    Registered User
    Join Date
    12-05-2015
    Location
    Auckland, New Zealand
    MS-Off Ver
    Mac 11
    Posts
    21

    Re: Same bid vendor

    Yes thanks
    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. Vendor comparison
    By psasp in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 04-19-2015, 10:08 AM
  2. Comparing vendor RFPs
    By bradleyandrewdavis in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 03-29-2015, 01:12 PM
  3. Conslidate Vendor data into one row
    By lorber123 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-04-2013, 11:40 AM
  4. auto numbering for different vendor
    By onestar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2012, 04:38 AM
  5. Lowest Cost Vendor
    By rafilip in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2012, 01:59 PM
  6. Lowest Cost Vendor
    By rafilip in forum Excel General
    Replies: 0
    Last Post: 06-25-2012, 01:31 PM
  7. [SOLVED] How do I set up a way to keep track of vendor invoices?
    By JoAnneCH in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-24-2006, 04:45 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