Finding the next record in a column

  • Thread starter Finding the next record in a column
  • Start date
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
 
E

Eduardo

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
 
K

KC

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top