LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove duplicate in a column but keep the record of the f sragor New Users to Excel 2 February 3rd 09 04:42 PM
Finding Duplicate Record in more than one column peterwhite Excel Discussion (Misc queries) 2 September 29th 08 12:56 PM
importing csv files- entire record goes into each column Bill[_3_] Excel Discussion (Misc queries) 7 March 28th 07 12:57 AM
Finding a record based on user input Soundman Excel Discussion (Misc queries) 5 June 21st 05 03:06 AM
Finding a record using multiple combo boxes as my search criteria sdg8481 Excel Discussion (Misc queries) 8 March 8th 05 08:36 PM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"