| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create sublist in new worksheet
I have one worksheet of all the people invited to an event. One column
indicates y for they're coming, n for they're not and blank if they have not yet replied. I want to set up a separate worksheet that lists *only* the acceptances. In other words, I want a separate worksheet that extracts the rows of data that contain y in column B but none of the other rows. Any advice? Madeline in Toronto |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RANK sublist | Excel Worksheet Functions | |||
| Create new workbook and new worksheet and close. Worksheet not sav | Excel Worksheet Functions | |||
| Form a sublist from a list using lookup | Excel Discussion (Misc queries) | |||
| Can I create a worksheet menu to select each other worksheet | Excel Discussion (Misc queries) | |||
| Drop Down Sublist | Excel Discussion (Misc queries) | |||
Threaded Mode
