View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default How do I find a change of data in an excel column ?

You can use the Goto Special Column Differences feature.

-Select the column.
-Press F5, Special, select Column Differences and OK.
-Press F4 thereafter to repeat.

--
Jim
"chriso" wrote in message
...
|I use large spreadsheets with the same data in a column. Once sorted I want
| to jump to where the data changes. What is the key sequence used ?