OK...Here the list:
A B C D
E
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


F2: (for AL14927021 PC is not at the first 4 rows, so I have to see nothing)
F3: (FOR AL14928383 pc is at the first 4 rows, so the result is): PC

I hope u can understand my hard explain.

--
BBB


"Max" wrote:

I lost you there on your new, actual query. Can you paste the sample table
again, this time, show the expected results in col F for every line down?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"AND" wrote in message
...
thanks for your interest Max, but I'm looking for a different solution:

I wanna that the formula check in the page what's the PC position for the
AL14927021 but it have to check if "PC" is before "PER" and it should do
the same job for many LVSNR else.