Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
search data?
Hi Experts,
i do not know what should the subject be, but it seen to be something like serch, therefore i put search data. Pardon if misunderstanings occur. I have columns A,B,C,D,E, F,G,H,I,J with values below: A B C D E F G H I J 1 2 4 5 6 1 2 0 nil 3A 2 2 6 6 9 2* 0 2 3 4AB 3 2 6 4 3 3 3 2 3 4AA The SEARCH will work something like this: users need to enter the value of from column F,G,H,I&J. then reults match, the value of column A,B,C,D,E will shown. Example: user enter 3,3,2,3,4AA, output will be 3264 Any ideas? it will best to make this more solid. Thanks first! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
search data?
Any experts to comment this? Even it is not workable. Thanks.
"kyoshirou" wrote: Hi Experts, i do not know what should the subject be, but it seen to be something like serch, therefore i put search data. Pardon if misunderstanings occur. I have columns A,B,C,D,E, F,G,H,I,J with values below: A B C D E F G H I J 1 2 4 5 6 1 2 0 nil 3A 2 2 6 6 9 2* 0 2 3 4AB 3 2 6 4 3 3 3 2 3 4AA The SEARCH will work something like this: users need to enter the value of from column F,G,H,I&J. then reults match, the value of column A,B,C,D,E will shown. Example: user enter 3,3,2,3,4AA, output will be 3264 Any ideas? it will best to make this more solid. Thanks first! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
search data?
It seems like Data|Filter|autofilter would do what you want.
You can filter to show your values in F, then filter in G, ... through J. If there are any visible rows, then those are all the records that match that criteria. kyoshirou wrote: Hi Experts, i do not know what should the subject be, but it seen to be something like serch, therefore i put search data. Pardon if misunderstanings occur. I have columns A,B,C,D,E, F,G,H,I,J with values below: A B C D E F G H I J 1 2 4 5 6 1 2 0 nil 3A 2 2 6 6 9 2* 0 2 3 4AB 3 2 6 4 3 3 3 2 3 4AA The SEARCH will work something like this: users need to enter the value of from column F,G,H,I&J. then reults match, the value of column A,B,C,D,E will shown. Example: user enter 3,3,2,3,4AA, output will be 3264 Any ideas? it will best to make this more solid. Thanks first! -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
search data?
Nope. That will going to create a long drop-down listing.
I refer if there's any better ways to do. Thanks Dave! "Dave Peterson" wrote: It seems like Data|Filter|autofilter would do what you want. You can filter to show your values in F, then filter in G, ... through J. If there are any visible rows, then those are all the records that match that criteria. kyoshirou wrote: Hi Experts, i do not know what should the subject be, but it seen to be something like serch, therefore i put search data. Pardon if misunderstanings occur. I have columns A,B,C,D,E, F,G,H,I,J with values below: A B C D E F G H I J 1 2 4 5 6 1 2 0 nil 3A 2 2 6 6 9 2* 0 2 3 4AB 3 2 6 4 3 3 3 2 3 4AA The SEARCH will work something like this: users need to enter the value of from column F,G,H,I&J. then reults match, the value of column A,B,C,D,E will shown. Example: user enter 3,3,2,3,4AA, output will be 3264 Any ideas? it will best to make this more solid. Thanks first! -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
search data?
I think much easier to make it work with Access data base.
kyoshirou wrote: Hi Experts, i do not know what should the subject be, but it seen to be something like serch, therefore i put search data. Pardon if misunderstanings occur. I have columns A,B,C,D,E, F,G,H,I,J with values below: A B C D E F G H I J 1 2 4 5 6 1 2 0 nil 3A 2 2 6 6 9 2* 0 2 3 4AB 3 2 6 4 3 3 3 2 3 4AA The SEARCH will work something like this: users need to enter the value of from column F,G,H,I&J. then reults match, the value of column A,B,C,D,E will shown. Example: user enter 3,3,2,3,4AA, output will be 3264 Any ideas? it will best to make this more solid. Thanks first! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
search data?
I can't imagine anything easier -- I guess you could spend lots of time trying
to build the same functionality, but that seems like a lot of work to me. kyoshirou wrote: Nope. That will going to create a long drop-down listing. I refer if there's any better ways to do. Thanks Dave! "Dave Peterson" wrote: It seems like Data|Filter|autofilter would do what you want. You can filter to show your values in F, then filter in G, ... through J. If there are any visible rows, then those are all the records that match that criteria. kyoshirou wrote: Hi Experts, i do not know what should the subject be, but it seen to be something like serch, therefore i put search data. Pardon if misunderstanings occur. I have columns A,B,C,D,E, F,G,H,I,J with values below: A B C D E F G H I J 1 2 4 5 6 1 2 0 nil 3A 2 2 6 6 9 2* 0 2 3 4AB 3 2 6 4 3 3 3 2 3 4AA The SEARCH will work something like this: users need to enter the value of from column F,G,H,I&J. then reults match, the value of column A,B,C,D,E will shown. Example: user enter 3,3,2,3,4AA, output will be 3264 Any ideas? it will best to make this more solid. Thanks first! -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
search data?
Hi Both,
I have managed to do it. U guys can try CONCATENATE the number of columns into a new worksheet. Follow by using VLOOKUP in the worksheet. It works something like a search engine. It can help to trigger the exact results when you have insert the actual values. Cheers "Bob I" wrote: I think much easier to make it work with Access data base. kyoshirou wrote: Hi Experts, i do not know what should the subject be, but it seen to be something like serch, therefore i put search data. Pardon if misunderstanings occur. I have columns A,B,C,D,E, F,G,H,I,J with values below: A B C D E F G H I J 1 2 4 5 6 1 2 0 nil 3A 2 2 6 6 9 2* 0 2 3 4AB 3 2 6 4 3 3 3 2 3 4AA The SEARCH will work something like this: users need to enter the value of from column F,G,H,I&J. then reults match, the value of column A,B,C,D,E will shown. Example: user enter 3,3,2,3,4AA, output will be 3264 Any ideas? it will best to make this more solid. Thanks first! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Search | Excel Discussion (Misc queries) | |||
Data Search | Excel Worksheet Functions | |||
Search through Data | New Users to Excel | |||
Search for data using 'contains' | Excel Discussion (Misc queries) | |||
Search data formulas - HELP!! | Excel Worksheet Functions |