Results 1 to 2 of 2

Thread: Excel Sort Question

  1. #1
    New Member Atif's Avatar
    Join Date
    Jan 2008
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post Excel Sort Question

    Is it possible to Sort excel in multiple columns when there is a formula in each column's cell?

    I was trying to Sort using Data >Sort and noticed that when I chose column Sort by - Column C it doesn't change other cells (ex. A, B, D & E) accordingly.

    Please note - Cell A contains Name like "Morningside" and others cells contains formula based numbers.

    When I remove formula using Paste values then my sorting works.

    Any suggestion how can I sort keeping all formulas in each cell.

    I am using Excel 2013.

    Thanks.
    Last edited by Joe4; Sep 4th, 2019 at 04:27 PM. Reason: fixed typo

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,913
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Excel Sort Question

    One option - use VBA to mirror whatever works manually

    Do all this in VBA
    - paste the required values into "NEW" temporary column immediately to the right of your data
    - ensure sort includes original table and new column(s)
    - sort data based on new column(s)
    - delete temporary column(s)

    Your formulas determine what needs to be done to make this work and whether it can be done in one step or a series of steps, but if you can do it manually, then I would expect VBA can be used to automate the process.
    Last edited by Yongle; Sep 5th, 2019 at 05:33 AM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •