Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Pivot Table
Hello All:
I am using Excel 2007. I have a worksheet with two columns of data. I need to compare the data between the two columns to find out which ones are missing. I cannot get this to work right in Excel 2007 using the PivotTable button. Any help is appreciated. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Pivot Table
One basic way to compare your data would be to set up a formula using the IF
Function in conjunction with the COUNTIF Function. Example: A C D Col 1 Data Col 2 Data No Match 1 1 2 2 3 3 4 4 7 5 7 The formula: =IF(COUNTIF(Col2Data, A2)=0, A2, " ") is propagated in Column D using fill handle. Col2Data is the Range Name given to Column C. "Anna_Stephanie" wrote: Hello All: I am using Excel 2007. I have a worksheet with two columns of data. I need to compare the data between the two columns to find out which ones are missing. I cannot get this to work right in Excel 2007 using the PivotTable button. Any help is appreciated. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - Pivot Table
Another way is as follows: Suppose your lists are A1:A10 and B1:B10. You can
use the following formula to get valyes common to the two lists: IF(COUNTIF($A$1:$A$10, B1)0, B1, " ") Replace B1 and $A$1:$A$10 with the first cells in the columns that contain the date that you want to extract. Note that this is an array formula and it can be first entered by using Ctrl+Shift +Enter instead of simply pressing Enter. The formula can be later edited the same way. Ciao! "Reb" wrote: One basic way to compare your data would be to set up a formula using the IF Function in conjunction with the COUNTIF Function. Example: A C D Col 1 Data Col 2 Data No Match 1 1 2 2 3 3 4 4 7 5 7 The formula: =IF(COUNTIF(Col2Data, A2)=0, A2, " ") is propagated in Column D using fill handle. Col2Data is the Range Name given to Column C. "Anna_Stephanie" wrote: Hello All: I am using Excel 2007. I have a worksheet with two columns of data. I need to compare the data between the two columns to find out which ones are missing. I cannot get this to work right in Excel 2007 using the PivotTable button. Any help is appreciated. Thanks. |
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) | |||
Pivot table with name range Excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
Excel 2007 Refresh Pivot Table | Excel Discussion (Misc queries) | |||
Excel 2007 Pivot Table | Excel Discussion (Misc queries) |