Tips: Domain account change information filtering \ user Data filtering

This article is purely for the hair Sao born, in line with the simplification engineer, the Administrator's workload to tidy up a practical and efficient method.

In the actual work, we have the following several scenarios appear:

• After importing and exporting the account information, the existing account information needs to be filtered and compared.

• Statistics The new user account information after the backup form data;

• Different period account information Status difference summary;

• Import and export account data information in batches;

• Or when the assets are counted, the duplicate data is screened and checked;

• The same table different time difference contrast, etc.;

General ideas:

The first column extracts one, then compares the second column in turn. Find out if it's different;

Then the first column pulls out the second one, and in turn compares the second column to find out if it is different;

or by using the functions in Excel to handle:

Similar to "=if (COUNTIF (A:A,B1) = 0," not duplicated "," ")";

or =if (ISERROR (MATCH (A1, $B $: $B $100000,0)), "", A1) This kind of method, because the function is too poor here is not to take out a disgrace, directly to a faster processing method.

Operation Method:

1. Organize the tables: summarize the data in the two tables to the same Excel in the table AB two columns (can be multiple columns);

2, select the two columns of data to be compared, choose Start conditional Format Highlight cell rule repeat value (D):

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/7A/03/wKioL1agq37gmc63AAEpZAJtFBM086.png "/>

3. After popping the duplicate Values window, select the "unique" or "repeat" option as required and select the process setting type value:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7A/04/wKiom1agq0Kxrl3hAAFgBKbssNs329.png "/>

4. View the relevant account information in the deep red box in the table:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/7A/04/wKiom1agq0PxHd1EAAAJySGmaNo933.png "/>

5, to this will be the difference, increment and so on the user timely statistics out, is not greatly speed up the processing speed it!

Hope to help you, if there is insufficient to welcome criticism, thank you.

Note:

When exporting account information in different ways, the values may vary, so when exporting an account, it is recommended that the uniform method (different export methods may show inconsistent format).

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7A/03/wKioL1agq4DyxMqUAABfLM-NYOI684.png "/>

This article from "Heard" blog, declined reprint!

Tips: Domain account change information filtering \ user Data filtering