I have two excel sheet and compare both sheet one column using python. Both column has string values and after comparison using loop, create another sheet like if first sheet has and second sheet do not have then print "found in first sheet" and if it is reverse then print "found in second sheet". and if found in both column then print mathces. Kindly refer the screen shot enter image description here. Still required more clarification please sent note I am trying to compare one column with same column number with other column number (Like Coumn A15 Compare O15) but this way result will not come. We have to compare Column A15 with all coumn of O (1 to end (Where the content available) Continue reading...
