+ Reply to Thread
Results 1 to 3 of 3

Sorted copy of a table

  1. #1
    Registered User
    Join Date
    10-09-2012
    Location
    Budapest, Hungary
    MS-Off Ver
    Excel 2010
    Posts
    2

    Sorted copy of a table

    First of all hello everyone, new member here.
    I'm sure this question was already asked, but I couldn't find it, sorry.

    I need to make a sorted copy of my data that updates automatically, so when I change a value in my original table, the other table automatically changes and sorts. The column by which I'd like to sort may contain identical data.

    Example:

    Original table:

    1 cc
    2 dd
    3 aa
    4 cc
    5 bb

    I need an automatically updating table next to it (or anywhere else):

    3 aa
    5 bb
    1 cc
    4 cc
    2 dd

    (This resulting table doesn't need to be secondary sorted by the first column.)

    I could solve this problem using a macro, but I need to solve it using formulas only. Is it possible?

    Thank you.

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Sorted copy of a table

    hi laszlo.kocsis, welcome to the forum. see if this link helps:
    http://chandoo.org/wp/2008/10/22/sor...sing-formulas/

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    10-09-2012
    Location
    Budapest, Hungary
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Sorted copy of a table

    Meanwhile I solved the problem in a bit more cumbersome way. Actually the second column were date fields (sorry for not mentioning it), so I could use a hidden column where I added Row()/1000 to the date and used small(range,Row()) to sort it. (I am aware that this can go wrong if I insert a new row above the table, I will make protections against it)

    But THANK YOU VERY MUCH for the tip, this COUNTIF smaller or larger values is really an AWESOME feature I hasn't known about so far. I may even reconstruct my current solution later. I just didn't understand yet how it could work on identical values, too. I will come back to think it over after my deadline

    cheers
    Last edited by laszlo.kocsis; 10-10-2012 at 04:06 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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