+ Reply to Thread
Results 1 to 2 of 2

Match formula doesn't recalculate rows when sorted

  1. #1
    Registered User
    Join Date
    10-19-2017
    Location
    Fort Saskatchewan, Alberta, Canada
    MS-Off Ver
    2010
    Posts
    10

    Match formula doesn't recalculate rows when sorted

    I have a =match formula in my spreadsheet. It works fine, until you do a sort. Then instead of recalculating which row the lookup value is in, it copies the cell number of the original placing. Any ideas?

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Match formula doesn't recalculate rows when sorted

    Hello,

    what exactly is your formula? What result does it show before sorting? What result does it show after sorting? Please provide a data sample and explain in context.

    cheers, teylyn

+ 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. Replies: 3
    Last Post: 08-07-2014, 06:01 AM
  2. Index Match Match Formula DOESN'T WORK WITH TABLES/TABLE NAMES ??
    By Underling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2014, 09:01 PM
  3. Replies: 3
    Last Post: 02-02-2014, 09:58 AM
  4. Formula to add rows if cell 2,1 doesn't match 3,1
    By flintcs in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-09-2013, 04:05 PM
  5. Userform updates cells in spreadsheet but doesn't recalculate other cell
    By david1987 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2012, 11:34 AM
  6. Replies: 3
    Last Post: 08-22-2012, 07:33 PM
  7. Match formula does not work when data is sorted
    By steinfm in forum Excel General
    Replies: 3
    Last Post: 11-22-2011, 09:39 PM

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