first sheet data in second sheet used or not

[johncena]

dear friends here i have attached my work sheet here.in my document first sheet has a data,second sheet i have use excel sumproduct function to make a summary.first sheet all data need use.my problem is i want to check first sheet all data in second sheet i have used or not.pls tell me how i can check it.if any body can make any conditional format formula or something to check.then easily i can understand missed one.

[JBeaucaire]

I looked at this yesterday and again this morning. No idea what you're asking.

Your two sheets could do a better job of being similar, too. Why is Poly Poly Core spelled differently on the two sheets?

[johncena]

@JBeaucaire

thanks lot for your effort.this first sheet data I'm taking from our system.that second sheet data i have made manually according to first sheet data.my problem is next month my system may will give new data then it will not be in my summary.i need to trace it.

[teylyn]

johncena, please stop quoting whole posts. They just clutter up the forum.

thanks