Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter (Criteria + Blanks)
Hi all, I've got a spreadsheet being used to flag missing dates in a tracking device. Each project in the tracker is assigned a Team Leader and is given two rows: one showing which dates are missing, and one below for them to fill in the dates. As there are over 400 projects and only five team leaders, I'd like them to be able to filter their own projects out (there's a column showing who's leading the project) and still have the blank row for them to fill in the necessary dates. My problem arises when I try to implement this filter. The 'Autofilter' option only allows one criteria to be used, and the 'Advanced Filter' appears not to allow one to use blanks. Can anyone suggest a means to get around this? I know the simplest way would be to have the fillable cells as columns - however, the spreadsheet has been designed to mirror another report where the dates will be copied and pasted, and hence I have to use rows for rapidity in getting the new information into the main report. Any help appreciated, TIA, SamuelT -- SamuelT ------------------------------------------------------------------------ SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501 View this thread: http://www.excelforum.com/showthread...hreadid=558451 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter criteria (formula) | Excel Worksheet Functions | |||
Need Advanced Filter with NOT equal string and OR criteria | Excel Discussion (Misc queries) | |||
Advanced filter and Criteria Range | Excel Discussion (Misc queries) | |||
advanced filter criteria "begins with" and "does not begin with" | Excel Worksheet Functions | |||
Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) |