LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AND AND is offline
external usenet poster
 
Posts: 22
Default looking for the next value

hello,
I have these data:
LVSNR AKNUS AKAVZ LVCOD LVARR
CJ03304442 872620080 16 VI SV
CJ03304442 872620080 41 VI SV
CJ03304442 872620080 41 VI SV
IU00789017 873050400 16 BZ MI11
IU00789017 873050400 16 BZ CO
MT21880207 872465980 07 MEL CZ
MT21880207 872465980 05 MEL MO
MT21880239 872466300 16 MEL CZ
MT21880239 872466300 16 MEL CZ

they are thousands rows, so I don't need of filter on, becouse they are too
much to be check one to one.

I need know
1.what's the line next a value. AND
2.what's the line before a value.
for example:
If I know this line:
IU00789017 873050400 16 BZ CO
1. I need to know the next line, tha's:
MT21880207 872465980 07 MEL CZ

and if I know this line:
MT21880239 872466300 16 MEL CZ
2. if I need to know the previous line, what's the way?:
MT21880207 872465980 07 MEL CZ

I know it is not easy, but I hope u can help me, becouse it's really
important for my job!.
thanks a lot to everyone wants help me.
--
Andrew
 
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



All times are GMT +1. The time now is 06:47 AM.

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

About Us

"It's about Microsoft Excel"