Thread: Detect The Value of one column in another column.

Hello friend I am working on Surpass shroud. I newer to surpass .I require to watch what are the elements of a tubing that exists in other paper are aforesaid elements to new the article. What is Surpass process I can use for this. Or is there any crosscut method for this.

I have also aforesaid difficulty.I have nearly 2000 records in Editorial 1 (a cypher consisting of letters and drawing). In Vertical 2 I have most 1500 records. All of the records in Column 2 are contained in Article 1. Withal, since almost 500 are absent I cannot variety the equalised values close to one added.How to eliminate it so that Excel matches the values in Column 2 succeeding to the like values in Column1. Any help would revalue.

Hey,Use provisional formulas to lightness duplicates.prototypical superior the article you requisite for duplicate.Go to conditional process and use process presumption beneath.Formula=COUNTIF($A:$A,$A1)>1 then choose any colourful adorn similar RED to attain duplicates propulsion out of.Assumes that A1 is the front content to be checkered for that.

Thanks to You...