View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
steven steven is offline
external usenet poster
 
Posts: 389
Default Cursor movement to last cell with same number

I have some spreadsheets and several columns within them have only six or
seven possible values. Currently I scroll through these columns manually to
find the breaks between numbers.

Is there a cursor control to move the cursor to the last cell to have the
same number as in the cell the cursor currently resides on?

For example:

4097
4097
4097
4097
4098
4098
4098

If I'm currently on a 4097 cell, I would want to move down to the last
4097-valued cell.