HarrysPrinters
New Member
- Joined
- Feb 27, 2009
- Messages
- 26
My spreadsheet consists of 2 list-dependant columns. A = School Name; B = Subject Choice. Data validation consists of ALL SCHOOLS in a given area and ALL SUBJECTS for our Province. Schools can appear in multiple consecutive rows due to various subject choices. I am capturing data as I receive it (hard copy response form). I NOW NEED TO RUN A 'REPORT' TO SEE WHICH SCHOOLS HAVE NOT RESPONDED. Tried the ADVANCED FILTER but this is too tedius as I have to copy unique records, paste them WITH the validation data, remove duplicates (those schools who have responded) and what is left are those schools who have not responded. Is there not a formula-driven method?