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