Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi to anyone who can help,
I have a spreadsheet that contains over 50 rows of data for each of several records. The first column displays the record name, the second a date, and the third a numerical value. There are 1625 different records, and so the spreadsheet has over 100,000 rows. Each row is labeled with the record number so the first column contains several duplicate record names. What i want to do is find a way to jump to the next record that is different from the one above because i need to highlight each record's data group. How do i jump to the next record in the column without just scrolling through? Example: Record Date Value 1 1/01 4 1 1/02 7 1 1/03 8 1 1/04 2 2 1/01 6 2 1/02 6 2 1/03 2 3 1/01 4 3 1/02 5 3 1/03 5 3 1/04 8 3 1/05 8 Thanks very much in advance EMily |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I remove duplicate in a column but keep the record of the f | New Users to Excel | |||
Finding Duplicate Record in more than one column | Excel Discussion (Misc queries) | |||
importing csv files- entire record goes into each column | Excel Discussion (Misc queries) | |||
Finding a record based on user input | Excel Discussion (Misc queries) | |||
Finding a record using multiple combo boxes as my search criteria | Excel Discussion (Misc queries) |