1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

short cut to jump between two exact duplicate value cells

Discussion in 'Ask an Excel Question' started by Uzzal, May 10, 2018.

  1. Uzzal

    Uzzal Member

    Messages:
    68
    Hi ! I have got huge number of duplicate cells by applying duplicate value formula of conditional formating. now is there any shortcut key to jump exactly to the same duplicate cell of the first one among the all different duplicate cells.
    Thanks
  2. Marc L

    Marc L Excel Ninja

    Messages:
    4,202

    Hi !

    Just use the Excel search inner feature …​
    Uzzal likes this.
  3. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    16,619
    Hi ,

    This can be done using VBA.

    Upload your workbook with the data in it , if you want this solution.

    Narayan
  4. Uzzal

    Uzzal Member

    Messages:
    68

    Attached Files:

  5. Uzzal

    Uzzal Member

    Messages:
    68
    Hi, Thanks for your response , file uploaded, so far I can remember I did it before (slided the selection cursor from the first cell to the other cell of the same pair of data) only using short cut key. is there really no short cut key to that ? I am confused with my weak memory.
    Thanks, you mean the Cntrl+F find option ?

    Attached Files:

  6. Marc L

    Marc L Excel Ninja

    Messages:
    4,202

    Yes, the Excel inner search feature …​
  7. p45cal

    p45cal Well-Known Member

    Messages:
    1,154
    In the attached two offerings:
    • Sheet GAP Air PP (hyplnk) if you click on a duplicate (after the first duplicate), it will take you to the first occurrence. There's a button to refresh the hyperlinks should things change or move about.
    • Sheet GAP Air PP (dblclk) If you double-click on a duplicate in column R, it will take you to the first of them. No updating required.

    Attached Files:

Share This Page