Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.worksheet.functions
|
|||
|
|||
multiple selection....
Pl don't multi-post.
I've responded in .misc -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple selection | Excel Discussion (Misc queries) | |||
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) |