How to match values for two columns while order could be different
Say I measured defect for a wafer twice, and have X, Y axis data for each defect.Some defects are repeat defect, they have very similar axis data (although not exact the same), so I would put "repeat" tag for them, while some defect do not have match, so I would put "new" tag for them.How do I write a formula to automatically do this? (ie: formula to auto make column "judge base on after") (Note t...