Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find function
Hi,
I wonder if anyone could help me with my problem. I have a list of data, and I want to sort out data by name, for example by project. If a user selects a prosject only the informations that contains this prosject name will be showed. Each prosject name have different sub groups, f eks. paid, repaid etc. When I use the look up function, I only get one observation. I want something like the filter function, but the criterion to sort by, should depend on a choice done in another cell. I will be greatefull for some help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find function
Doesn't DataSort and DataFilterAutofilter do just what you want?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kris" wrote in message ... Hi, I wonder if anyone could help me with my problem. I have a list of data, and I want to sort out data by name, for example by project. If a user selects a prosject only the informations that contains this prosject name will be showed. Each prosject name have different sub groups, f eks. paid, repaid etc. When I use the look up function, I only get one observation. I want something like the filter function, but the criterion to sort by, should depend on a choice done in another cell. I will be greatefull for some help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find function
Yes, it does. But what I what is that the drop down meny from autofilter
should select the same value as another cell futher up in the sheet. Bob Phillips skrev: Doesn't DataSort and DataFilterAutofilter do just what you want? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kris" wrote in message ... Hi, I wonder if anyone could help me with my problem. I have a list of data, and I want to sort out data by name, for example by project. If a user selects a prosject only the informations that contains this prosject name will be showed. Each prosject name have different sub groups, f eks. paid, repaid etc. When I use the look up function, I only get one observation. I want something like the filter function, but the criterion to sort by, should depend on a choice done in another cell. I will be greatefull for some help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find function | Excel Worksheet Functions | |||
#VALUE about function Find | Excel Worksheet Functions | |||
find function | Excel Programming | |||
Help with find function please! | Excel Programming | |||
backwards find function to find character in a string of text | Excel Programming |