Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |