+ Reply to Thread
Results 1 to 12 of 12

Picking the value in line by ascending order

  1. #1
    Registered User
    Join Date
    02-19-2018
    Location
    Lisbon
    MS-Off Ver
    2016
    Posts
    13

    Picking the value in line by ascending order

    I want a formula (only one) to put in cells (yellow):
    -search in line
    -search only the number behind the "lote DMTC"
    -put the number in ascending order (see example)

    Example
    Capturar.PNG

    I hope some master can help me.
    Thank you

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Picking the value in line by ascending order

    pl attach file showing requred result.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Picking the value in line by ascending order

    pl see attach file showing requred result.
    ARRAY formula in N2 then drag across.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-19-2018
    Location
    Lisbon
    MS-Off Ver
    2016
    Posts
    13

    Re: Picking the value in line by ascending order

    unfortunately it does not work because there are repeated numbers and I dont repeat number in yellow cells

    Thank you for help

  5. #5
    Registered User
    Join Date
    02-19-2018
    Location
    Lisbon
    MS-Off Ver
    2016
    Posts
    13

    Re: Picking the value in line by ascending order

    Quote Originally Posted by kvsrinivasamurthy View Post
    pl see attach file showing requred result.
    ARRAY formula in N2 then drag across.
    Please Login or Register  to view this content.
    This is file,

    thansk for help
    Attached Files Attached Files

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Picking the value in line by ascending order

    This will work in your version of Excel.

    In Y4 and fill across.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  7. #7
    Registered User
    Join Date
    02-19-2018
    Location
    Lisbon
    MS-Off Ver
    2016
    Posts
    13

    Re: Picking the value in line by ascending order

    Quote Originally Posted by FlameRetired View Post
    This will work in your version of Excel.

    In Y4 and fill across.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    I need to ctrl+shift+enter?
    If not they give me some errors. Can u put in my file for I see how u did it?

    Thank you for help

  8. #8
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Picking the value in line by ascending order

    No. The formula can be committed with just 'Enter'.

    Here is the file.

  9. #9
    Registered User
    Join Date
    02-19-2018
    Location
    Lisbon
    MS-Off Ver
    2016
    Posts
    13

    Re: Picking the value in line by ascending order

    Quote Originally Posted by FlameRetired View Post
    No. The formula can be committed with just 'Enter'.

    Here is the file.
    Its works, but in my big file dont work because say too few arguments...
    What are the mean of 15,6,1?
    Attached Files Attached Files
    Last edited by kREM1993; 02-22-2018 at 07:37 PM.

  10. #10
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Picking the value in line by ascending order

    Quote Originally Posted by kREM1993 View Post
    Its works, but in my big file dont work because say too few arguments...
    What are the mean of 15,6,1?
    The latest upload does not reflect that since there is no example of a formula in it.
    What are the mean of 15,6,1?
    The 15 is the AGGREGATE function_number for SMALL. The 6 is the option to ignore errors. You can read about those in the Help feature of Excel. The 1 is part of the math operations that follow it.
    Try this formula in BV4 and fill across.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I get these returns in the latest upload:


    BV
    BW
    BX
    BY
    BZ
    CA
    1
    2
    3
    1
    lote X
    2
    lote X
    3
    lote X
    4
    lote X
    5
    lote X
    6
    lote X
    4
    634
    635
    637
    638
    0
    0
    Last edited by FlameRetired; 02-22-2018 at 10:08 PM.

  11. #11
    Registered User
    Join Date
    02-19-2018
    Location
    Lisbon
    MS-Off Ver
    2016
    Posts
    13

    Re: Picking the value in line by ascending order

    Quote Originally Posted by FlameRetired View Post
    The latest upload does not reflect that since there is no example of a formula in it.
    The 15 is the AGGREGATE function_number for SMALL. The 6 is the option to ignore errors. You can read about those in the Help feature of Excel. The 1 is part of the math operations that follow it.
    Try this formula in BV4 and fill across.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I get these returns in the latest upload:


    BV
    BW
    BX
    BY
    BZ
    CA
    1
    2
    3
    1
    lote X
    2
    lote X
    3
    lote X
    4
    lote X
    5
    lote X
    6
    lote X
    4
    634
    635
    637
    638
    0
    0
    Thank you so much for your help.

    I finnally finish my study!

    Thank you again

  12. #12
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Picking the value in line by ascending order

    You are welcome. Thank you for the feedback and rep.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.

+ 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. Ascending Order
    By isaackoh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-26-2014, 10:59 AM
  2. Ascending Order
    By isaackoh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2014, 06:49 AM
  3. [SOLVED] Generate "ascending order no" for columns of data that are not in order
    By abreichenbach in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-20-2013, 02:22 AM
  4. Re: Bar Graph in ascending order
    By newbie4 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-23-2012, 05:49 AM
  5. Replies: 10
    Last Post: 09-27-2012, 03:59 PM
  6. ascending order
    By cbian in forum Excel General
    Replies: 2
    Last Post: 06-05-2008, 07:26 AM
  7. Ascending order and IF
    By kookinuttz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-07-2007, 08:27 AM

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