Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple search - formulas
Hi - I wrote a similar query yesterday but I don't think I explained myself
very well. What i'm doing is creating a Excel Spreadsheet, with 2 tabs - one which is a datadump with a large amount of information E.g Name, Customer,Date,Location. The other tab will be a front page search doc. What i'm looking to do is on the first page, another user who is not too good with formulas and excel and enter in a cell a value which will then show up in the cells below which will have formulas. What i want to do though is what i'm not sure is possible - If another user accesses the database looking for Fred, and then it shows all the freds below, but then only wants the freds living in Texas, then it will sort by texas only, and then maybe another search to break it down by Freds aged 60...... So any help would be extremely appreciated - and if you could put it in laymen terms, would really appreciate :D Thanks Ben |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple search - formulas
The ability to limit what you see in a database in Excel is usually done with
AutoFilter. See: http://www.contextures.com/xlautofilter01.html -- Gary''s Student - gsnu200781 "B_cooper123" wrote: Hi - I wrote a similar query yesterday but I don't think I explained myself very well. What i'm doing is creating a Excel Spreadsheet, with 2 tabs - one which is a datadump with a large amount of information E.g Name, Customer,Date,Location. The other tab will be a front page search doc. What i'm looking to do is on the first page, another user who is not too good with formulas and excel and enter in a cell a value which will then show up in the cells below which will have formulas. What i want to do though is what i'm not sure is possible - If another user accesses the database looking for Fred, and then it shows all the freds below, but then only wants the freds living in Texas, then it will sort by texas only, and then maybe another search to break it down by Freds aged 60...... So any help would be extremely appreciated - and if you could put it in laymen terms, would really appreciate :D Thanks Ben |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating formulas using text in the search criteria | Excel Discussion (Misc queries) | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Search data formulas - HELP!! | Excel Worksheet Functions | |||
Search - replace NOT in formulas | Excel Worksheet Functions | |||
search formulas | Excel Discussion (Misc queries) |