| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple selection on a combo box | Excel Worksheet Functions | |||
| Multiple cell selection | Excel Discussion (Misc queries) | |||
| How do I allow a multiple selection from a dropdown? | Excel Discussion (Misc queries) | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| multiple selection in combo box | Excel Discussion (Misc queries) | |||
Linear Mode
