F
Finding the next record in a column
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
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