Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - filtering, sorting?
Hay everyone! I have one problem in Excel and I'll try to explain it. It is complex table (with formulas, etc.) but I have problem with one column. In this column are "Products" - all kinds, but I have to make sort within categories- category of "carbonated" and "non-carbonated" product. In all this table it is no specification which product is "csd" or "noncsd". So, my problem is how can I make filter for categories if there is no specification? This table I got it because they want filter for "csd" and "noncsd". I have tried on a new sheet to specify those categories for each brand and flavour but I do not know how to link (or something else) it with existing sheet that have all the data. Can you help me, please. Thnaks!:) -- feliks27 ------------------------------------------------------------------------ feliks27's Profile: http://www.excelforum.com/member.php...o&userid=33770 View this thread: http://www.excelforum.com/showthread...hreadid=535434 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - filtering, sorting?
If you have another table with the carbonation information for each
product, you could use a VLookup formula to return the data in the complex table. There's information here on VLookup: http://www.contextures.com/xlFunctions02.html feliks27 wrote: Hay everyone! I have one problem in Excel and I'll try to explain it. It is complex table (with formulas, etc.) but I have problem with one column. In this column are "Products" - all kinds, but I have to make sort within categories- category of "carbonated" and "non-carbonated" product. In all this table it is no specification which product is "csd" or "noncsd". So, my problem is how can I make filter for categories if there is no specification? This table I got it because they want filter for "csd" and "noncsd". I have tried on a new sheet to specify those categories for each brand and flavour but I do not know how to link (or something else) it with existing sheet that have all the data. Can you help me, please. Thnaks!:) -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Filtering an Excel List formatted to AED Currency | Excel Discussion (Misc queries) | |||
Excel Filtering | Excel Discussion (Misc queries) | |||
ADVANCED FILTERING IN EXCEL 2003 | Excel Discussion (Misc queries) | |||
An issue when sorting in excel PivotTable | Excel Discussion (Misc queries) |