Use of Parameters in Excel

[sarjak]

I inherited a 7 column 2900 row spreadsheet. I do not have access
to Access nor Crystal Reports. I need to be able to create a paramete
field
to narrow down the data in one particular column, so it is manageable
As I said, Access and Crystal are not options in this case. Is i
possible to create a parameter field in Excel and if so, could someon
point me in the right direction?

Thanks for anything! !
:eek

 

[vezerid]

sarjak,

what you are saying is certainly possible, though it is not clear what
exactly you want to do.
- Do you want to make a field narrower, i.e. display only some of its
characters?
- Do you want to compute a condition for each row, so that you can then
apply a filter for true?

Please be more specific

Kostis Vezerides

 

[sarjak]

I would like to extract records from the spreadsheet based
on values (may be more than one value) that are entered into Column C
The results from the parameter query would then be copied and pasted t
another workbook to complete a monthly report.
Thank

 

[Mark Lincoln]

Sarjak,

Highlight the column of data, including the header label. Then go to
Data | Filter... and click on AutoFilter. In the header cell, you'll
see an arrow. Click on it, choose Custom from the drop-down list, and
enter your parameters. The list will then only show those rows that
fit your parameters.

 

[sarjak]

The filter only gives me the ability to choose 2 criteria.
I am in need of more criteria options. At least 4-

 

[vezerid]

It seems you need the Advanced Filter. But before this...

Assume you want all records that have
- value 4 in column B:B (say header is Num)
- value "yes" in column C:C (say header is Accepted)
- values 1, 2, 5, 10 or 20 in column F:F (say header is Multiple)

You need to use a separate area where you will first input the three
headers (Num, Accepted, Multiple) as they appear in the original table.
Under Num you enter 4. Under Accepted you enter yes (no quotes if no
quotes appearing in data). Under Multiple, in successive rows, you
enter 1, 2, 5, 10, 20.

This is the setup for a query with AND(.., .., OR)

From this point on, check the documentation on Advanced Filter.

HTH
Kostis Vezerides

 

[sarjak]

THANK YOU THANK YOU THANK YOU~~~~~

That was what I was looking for!
THANK YOU SOOOO MUCH!!!

Problem Solved.

(May a flock of geese fly over your car, *upside down*, the next time
you wash it!! )

 

[vezerid]

Glad to know it worked.

Regards,
Kostis