| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fiterling merged cells
If I am to use the auto filter function on the table, (pls see attached spreadsheet), for example for order FG38169, there are 10 items, since I have merged the cells G6:G15, when I choose FG38169 from the drop-down menu, it only shows the row contains Item 1, but not the rest of the 9 items in the same order. How can I make it to show all items within the same order number? thanks -- vickyho1008 ------------------------------------------------------------------------ vickyho1008's Profile: http://www.excelforum.com/member.php...fo&userid=8169 View this thread: http://www.excelforum.com/showthread...hreadid=568257 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
| Linking Merged Cells | Excel Worksheet Functions | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
Threaded Mode
