Why not just apply autofilter (DataFilterAutofilter),
then select say: PC from the droplist for "AKCOD" ?

Or, you could select from the "LVSNR" droplist first eg: AL14927021,
then select: PC from the droplist for "AKCOD" (or the other way around)
to filter out only those rows satisfying this dual criteria?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"AND" wrote:
I have these data:
LVSNR date time AKAVZ AKCOD
AL14927021 1002 1658 27 TO1
AL14927021 1002 1916 16 TO1
AL14927021 1102 0710 01 PER
AL14927021 1102 0710 01 AT
AL14927021 1102 2057 21 PC
AL14927021 1202 0256 21 PC
AL14927021 1202 0816 01 AT
AL14927021 1202 0816 01 PER
AL14927021 1202 0920 03 AT
AL14928383 1002 2123 16 TO1
AL14928383 1002 2125 16 TO1
AL14928383 1102 0422 21 PC
AL14928383 1102 0803 01 PER

what's the worksheet function to select ,on the basis of LVSNR, a definite
AKCOD??
I need a formula to built this kind of sintax:
If "AKCOD"(for example PC) of a"LVSNR"(selected in the worksheet function,
for example, AL14927021)is between the first and the 4th data then I wanna
see the number of its position else "X".

for example:
for the AL14927021, I wanna know what's the PC position
the result is "X".

Please help me. I don't know how I can solve this issue so I can't finish my
job report!!!!
thanks a lot to everyone want help me.
--
BBB