+ Reply to Thread
Results 1 to 5 of 5

Dynamically move cell value when adjacent cell is sorted

  1. #1
    Registered User
    Join Date
    09-05-2019
    Location
    N/A
    MS-Off Ver
    For Mac 16.26
    Posts
    10

    Dynamically move cell value when adjacent cell is sorted

    sheet.PNG

    Hi everyone. In the table I have depicted above, I am trying to make the values in column C shift dynamically when column B gets updated.

    Use:
    1) Values are input into column A. Column B then sorts these using a SORT formula.
    2) Y or N values are input into column C in respect to the value in column B.
    3) Later on, I add another value into column A, cell A10. For example, value "alpha".
    Column B will sort this, and place "alpha" in cell B2, pushing "hotel" down to B3.
    Column C will stay as it is, but this is not what I want. Is there a way for the values in column C to dynamically move so that the entered values shift with their corresponding cells from column B?

    Please find sample spreadsheet attached.

    Thank you for your help!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,378

    Re: Dynamically move cell value when adjacent cell is sorted

    Power Query
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-05-2019
    Location
    N/A
    MS-Off Ver
    For Mac 16.26
    Posts
    10

    Re: Dynamically move cell value when adjacent cell is sorted

    Thanks Czeslaw! I think you're right to suggest that Power Queries is the way to solve this, but your solution isn't doing what I need.

    The value entered in the 'Process' column needs to be in relation to the 'Sorted' column, not the 'Input' column. So when more data is entered into the 'Input' column, the 'Process' values need to shift with the 'Sorted' values.

    Is this possible? Perhaps there need to be multiple power queries?

  4. #4
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2408 and WPS V2024(12.1.0.18543)
    Posts
    3,834

    Re: Dynamically move cell value when adjacent cell is sorted

    pls try this formula

    Cell F2 formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-05-2019
    Location
    N/A
    MS-Off Ver
    For Mac 16.26
    Posts
    10

    Re: Dynamically move cell value when adjacent cell is sorted

    Hi wk9128. Thank you, but that's not working either.

    I entered your formula in F2. This is what I'm getting. The results in column G are NOT what I want. 'lima' should be 'N', 'november' should be 'Y'.
    Capture1.JPG

    Then if I enter 'alpha' into A10, all the results in Column G are incorrect again.
    Capture2.JPG

    Is there a way to have column B & C always paired? Particularly when more data is entered into column A?
    Last edited by Leaflock; 04-14-2023 at 02:56 AM.

+ 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] Dynamically update cells depending on content of adjacent cell
    By markmcm2021 in forum Office 365
    Replies: 3
    Last Post: 08-10-2022, 05:21 AM
  2. Replies: 4
    Last Post: 08-06-2018, 11:19 AM
  3. Move last word to adjacent cell .
    By Abinash4 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2014, 09:32 PM
  4. Help to move value into first empty cell and adjacent cell please
    By susmahaffy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-01-2014, 02:11 PM
  5. Move Text dynamically to another cell
    By st4more in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-03-2010, 04:23 PM
  6. User form to display adjacent cell value and move to next blank cell
    By Ketel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2008, 03:15 PM
  7. How to Automatically Move Cell datato adjacent cell..
    By cardingtr in forum Excel General
    Replies: 1
    Last Post: 10-16-2005, 10:59 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