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

Hi,
you can apply a filter and filter it for the record you are looking for, to
do that positioned in cell A1,data, filter

"Finding the next record in a column" wrote:

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

emily,

Select A2 which contains 1 as the record number

then goto Format Conditional Formatting

Condition 1:
'Formula Is' =($A1<$A2)
then click 'Format' (which is on the right side of the condition 1) goto
Patterns tab and select any color (eg, yellow)

Now add 2nd condition by clicking 'Add '

Condition 2:
Formula Is: =($A1=$A2)
then click 'Format' (which is on the right side of the condition 2) goto
Patterns tab and select any different color this time(eg, Green)

Click OK. and come back to the sheet.
now you need to apply this condition to all the other rows and columns, you
can do this by first selecting A2 (which has the conditional formatting), and
select the 'Format Painter' from toolbar and paste it to all the cells.

if everything goes on well, then you should be able to see yellow
highlighted rows where ever the new record starts and rest of the rows as
green.

-kc
*Click YES if this helps







"Finding the next record in a column" wrote:

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