+ Reply to Thread
Results 1 to 2 of 2

SORT all rows depending on value

  1. #1
    Forum Contributor
    Join Date
    04-16-2020
    Location
    Tehran, Iran
    MS-Off Ver
    2019 v2306
    Posts
    145

    SORT all rows depending on value

    Hello
    I need sort automatic my data when they reach value
    please look at my attached file : when "P" reach value as "6" then gets to top of the list automatically.

    thank you in advance
    https://www.excelforum.com/attachmen...1&d=1658577176
    Last edited by soubasa; 07-23-2022 at 09:55 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: SORT all rows depending on value

    E1:
    =IFERROR(LARGE($A$1:$A$25,ROWS(E$1:E1)),"")

    F1:
    =INDEX(B:B,AGGREGATE(15,6,ROW($A$1:$A$20)/($A$1:$A$20=E1),COUNTIF($E$1:$E1,E1)))

    The white on black drove me mad...
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help 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. [SOLVED] Permanently sort a Col depending on Colour
    By batexcel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-11-2019, 11:18 AM
  2. Export and sort data depending on dates from one book to another.
    By lababa in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-26-2018, 09:23 AM
  3. [SOLVED] Sort depending on last column
    By gandreso in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2016, 03:43 AM
  4. [SOLVED] Custom sort depending on specific letters
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-02-2015, 09:29 AM
  5. [SOLVED] Sort depending of previous selection
    By luis6777 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-12-2014, 04:53 PM
  6. Sort array depending on 2nd column
    By pmguerra in forum Excel General
    Replies: 22
    Last Post: 04-15-2010, 06:10 AM
  7. How to sort a column depending on number of letters
    By julia81 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-16-2008, 03:38 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