Multiple search - formulas

  • Thread starter Thread starter B_cooper123
  • Start date Start date
B

B_cooper123

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top