Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Database - mulitple selection
I have database of sales info.
I need to filter for a list of 10 customers who bought a list of 20 items. With the custom filtering, i can only select 2 customers or 2 partno. each time. How can I get around this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Database - mulitple selection
You could use Advanced Filter - Debra Dalgleish has some notes he
http://www.contextures.com/xladvfilter01.html Alternatively, you could list your 10 customers elsewhere in your sheet, eg X1:X10, and then in a helper column you could have a formula like: =IF(ISNA(MATCH(A2,X$1:X$10,0)),"no","yes") copied down, assuming your customer name is in column A. Then you could apply the autofilter to the helper column and select yes from the pull-down. You could do a similar thing for the 20 items bought. Hope this helps. Pete On Oct 23, 3:52*am, "Christine" wrote: I have database of sales info. I need to filter for a list of 10 customers who bought a list of 20 items.. With the custom filtering, i can only select 2 customers or 2 partno. each time. How can I get around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Using a ListBox selection to query a database | Excel Discussion (Misc queries) |