Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table 'Validation'?
Let's say I have a table, a database, as it were, in Excel. Each
record consists of a date, a person's name, and a couple of other things. The name field is validated by a list on another sheet. But not only do I want to restrict the names on the DB to names on the validation list, I expect every name on that list to eventually show up in the DB. Is there a way I can do a pivot table or something to get information from the DB and include the master of names to also show who isn't showing up? I know it isn't the 'show items with no data' field option. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table 'Validation'?
Hi,
I tend to use VLOOKUPs for things like this. Something like in a column: =IF(ISNA(VLOOKUP(Name, Masterlist, 1, False)),"Y","N") And then filter on the "N"s to see which Names are missing. Cheers, Matt "Slim Slender" wrote: Let's say I have a table, a database, as it were, in Excel. Each record consists of a date, a person's name, and a couple of other things. The name field is validated by a list on another sheet. But not only do I want to restrict the names on the DB to names on the validation list, I expect every name on that list to eventually show up in the DB. Is there a way I can do a pivot table or something to get information from the DB and include the master of names to also show who isn't showing up? I know it isn't the 'show items with no data' field option. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions |