+ Reply to Thread
Results 1 to 3 of 3

Formula to Indicate Alphabetical Data Connected to Numeric Data

  1. #1
    Registered User
    Join Date
    01-08-2014
    Location
    Austin
    MS-Off Ver
    Excel 2010
    Posts
    7

    Formula to Indicate Alphabetical Data Connected to Numeric Data

    I have a question about using conditional formatting in excel (2010); I made a table with the following columns: “Supplier Name” “Supplier Lead Time” “Internal Lead Time” “Total Lead Time” (If you need to see the table to visualize, please email me at t.cluer@gmail.com). I made two different scenarios to show different supplier lead times and different internal lead times, and used the minimum function in the "Total Lead Time" column to find the smallest total lead time to help select the best supplier.
    The last thing I would want to do with this set of data, which I am consequently asking for help with, is plug in a formula that would somehow indicate which supplier corresponds to the shortest total lead time (which supplier has the smallest supplier lead time). I’d like to be able to use a formula that enters the name of the supplier in a designated cell, which I could indicate as the “Preferred Supplier” cell. If this is not possible perhaps there is a way to highlight the supplier’s name with conditional formatting? Any help achieving my goal with either method would be very appreciated.

    Thank you,
    Tim

  2. #2
    Registered User
    Join Date
    11-26-2013
    Location
    Norway
    MS-Off Ver
    Excel 2013
    Posts
    67

    Re: Formula to Indicate Alphabetical Data Connected to Numeric Data

    Could there be two suppliers with the same lead-time?
    If not you might want to check out INDEX and MACTH, maybe something like this if your suppliers are from A2:A5 and leadtimes from D2:D5:

    INDEX(A2:A5,MATCH(MIN(D2:D5),D2:D5,0))
    Best regards

    Per Erik Midtrød

  3. #3
    Registered User
    Join Date
    01-08-2014
    Location
    Austin
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Formula to Indicate Alphabetical Data Connected to Numeric Data

    Thank you, I will try it out post results asap.

    Edit: Might be operator error but excel is telling me there are two few arguments. I have to switch tasks for the time being but will attempt again later tonight.

    Thanks,
    Tim

    Edit: Worked! Thank you
    Last edited by tcluer; 01-09-2014 at 09:32 PM.

+ 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] Extracting only numeric data from combined numeric & non-numeric data
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-20-2013, 11:51 AM
  2. [SOLVED] From alfa numeric data, substitute numeric data.
    By manharji in forum Excel General
    Replies: 6
    Last Post: 04-06-2012, 10:49 PM
  3. Excel 2007 : How to search and quantify connected data?
    By Sarianna in forum Excel General
    Replies: 2
    Last Post: 10-05-2011, 06:05 AM
  4. Replies: 2
    Last Post: 01-01-2006, 02:10 PM
  5. Replies: 1
    Last Post: 10-19-2005, 10:05 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