multiple selection
 

hello,
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

multiple selection
 

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

multiple selection
 

thanks for your support Max.
I have already thought to that way, but the data I'm going to check are
thousands: I need of that formula to analize hundreds of data.
Can you help me please?
--
BBB


"Max" wrote:

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

multiple selection
 

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

Assuming your source data in cols A to E,
and you want to flag it in an adj. col F based on the 2 conditions
then this formula in F2, copied down:
=IF(AND(A2="AL14927021",E2="PC"),"X","")
will do it

Mark this response, press the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"AND" wrote:
thanks for your support Max.
I have already thought to that way, but the data I'm going to check are
thousands: I need of that formula to analize hundreds of data.

multiple selection
 

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.

If you can help me.
thank you.
--
BBB


"Max" wrote:

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

Assuming your source data in cols A to E,
and you want to flag it in an adj. col F based on the 2 conditions
then this formula in F2, copied down:
=IF(AND(A2="AL14927021",E2="PC"),"X","")
will do it

Mark this response, press the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"AND" wrote:
thanks for your support Max.
I have already thought to that way, but the data I'm going to check are
thousands: I need of that formula to analize hundreds of data.

multiple selection
 

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.

multiple selection
 

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.

multiple selection
 

Assuming you have these listed in F2:F3
AL14927021
AL14928383

Put in G2, normal ENTER to confirm:
=IF(MATCH(1,INDEX((A$2:A$14=F2)*(E$2:E$14="PC"),), 0)-MATCH(F2,A$2:A$14,0)+1<=4,"PC","")

Copy G2 down to derive the expected results, viz:

AL14927021 <nothing
AL14928383 PC

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"AND" wrote:
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

multiple selection
 

thank you Max.
U was very cute!
I got the solution. Thank u again!


--
BBB


"Max" wrote:

Assuming you have these listed in F2:F3
AL14927021
AL14928383

Put in G2, normal ENTER to confirm:
=IF(MATCH(1,INDEX((A$2:A$14=F2)*(E$2:E$14="PC"),), 0)-MATCH(F2,A$2:A$14,0)+1<=4,"PC","")

Copy G2 down to derive the expected results, viz:

AL14927021 <nothing
AL14928383 PC

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"AND" wrote:
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

multiple selection
 

Welcome. Glad it worked out ok for you
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"AND" wrote in message
...
thank you Max.
U was very cute!
I got the solution. Thank u again!