• 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...

  • 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

Uzzal

Member
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
 
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.
Hi !

Just use the Excel search inner feature …​
Thanks, you mean the Cntrl+F find option ?
 

Attachments

  • For Chandu dot com.xlsx
    56.2 KB · Views: 3
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.
 

Attachments

  • Chandoo38486For Chandu dot com.xlsm
    109.9 KB · Views: 1
Back
Top