Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
I have columns representing company, company's product, and company street address. all this information is in a row. i have about 800 rows in my spreadsheet. i want to filter this spreadsheet so it contains only products that are made by 10 companies or less. that is, i want to be relatively selective in choosing products that are not made by a lot of companies, just 10 or less. how do you suggest i do this in Excel? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there a way to link Auto Filter values to a Cell | Excel Worksheet Functions | |||
Refresh advanced filter | Excel Discussion (Misc queries) | |||
Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |