Sometimes, I need to compare two columns to find out missing value
such as column a contains list of orderid from one script while column b contains list of orders from another script
Since two scripts are running on different env, the only way to compare is to copy and paste to excel.
Now if list contains thousands of orders, it is inhumane to go through each row
Here is the solution: http://en.kioskea.net/forum/affich-456715-find-missing-data-in-2-columns-excel
use COUNTIF function in excel
Suppose A column contains less orders than E
You want to find out how many are missing in column
=IF(COUNTIF(A$2:A$3730,E2521)=0,E2521,"")
Remember to use $
What it does it to take each value in E column and go through the whole A column, if there is no match, display that value from Column E
Neat !
No comments:
Post a Comment