Use of Parameters in Excel
 

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 parameter
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 it
possible to create a parameter field in Excel and if so, could someone
point me in the right direction?

Thanks for anything! !
:eek:


--
sarjak
------------------------------------------------------------------------
sarjak's Profile: http://www.excelforum.com/member.php...o&userid=29402
View this thread: http://www.excelforum.com/showthread...hreadid=507314

Use of Parameters in Excel
 

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

Use of Parameters in Excel
 

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 to
another workbook to complete a monthly report.
Thanks


--
sarjak
------------------------------------------------------------------------
sarjak's Profile: http://www.excelforum.com/member.php...o&userid=29402
View this thread: http://www.excelforum.com/showthread...hreadid=507314

Use of Parameters in Excel
 

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.

Use of Parameters in Excel
 

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


--
sarjak
------------------------------------------------------------------------
sarjak's Profile: http://www.excelforum.com/member.php...o&userid=29402
View this thread: http://www.excelforum.com/showthread...hreadid=507314

Use of Parameters in Excel
 

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

Use of Parameters in Excel
 

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!! )


--
sarjak
------------------------------------------------------------------------
sarjak's Profile: http://www.excelforum.com/member.php...o&userid=29402
View this thread: http://www.excelforum.com/showthread...hreadid=507314

Use of Parameters in Excel
 

Glad to know it worked.

Regards,
Kostis