+ Reply to Thread
Results 1 to 2 of 2

Lowest to highest Problem with duplicate value

  1. #1
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Lowest to highest Problem with duplicate value

    hi i have a data liek this

    A B C D E F G
    EGSACAY JALDS A.LGANTUANGCO SORSOGON COM. JRS MOVERS EXPERTOLOGISTICO ANSALDO LOGISTICS
    50,000.00 68,800.00 49,900.00 50,000.00 65,000.00 50,000.00 45,000.00

    Now what i want is , i want the finish data like this in other ****

    A1: ANSALDO LOGISTICS : 45,000.00
    A2: GANTUANGCO : 49,900.00
    A3: EG SACAY : 50,000.00
    A4: SORSOGON : 50,000.00
    A5: EXPERTO LOGISTIC : 50,000.00
    A6: JRS MOVE : 65,000.00
    A7: JALDS : 68,800.00


    i want the values to be sorted using formula. lowest to highest. help me please

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,523

    Re: Lowest to highest Problem with duplicate value

    See here.
    http://www.excelforum.com/excel-prog...ml#post4189597

+ 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] how to find the lowest to highest value and display the name who is the lowest and the hig
    By jasond1992 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 09-23-2015, 09:20 PM
  2. Replies: 9
    Last Post: 05-06-2013, 04:48 AM
  3. How can I get the highest and lowest value???
    By iochoa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2012, 02:17 AM
  4. Excel 2007 : Highest to lowest problem
    By Perebrine in forum Excel General
    Replies: 8
    Last Post: 08-27-2011, 04:20 AM
  5. Replies: 8
    Last Post: 09-24-2009, 06:13 PM
  6. Highest and Lowest Value
    By Kingo in forum Excel General
    Replies: 12
    Last Post: 08-07-2009, 04:25 AM
  7. [SOLVED] lowest via highest nums!
    By stewart08 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-05-2008, 04:28 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