I want to compare the two columns from different excel sheets ,each row has fixed names , if the row name matches with row name in another excel then we need to compare the values ,if values are not same we need to take the difference ,please help me
I think in second excel file, there is only value column ?
testex2.xlsx (8.2 KB)
sorry my bad , second excel also have name columns
Actually what u need to do if they had same name ?
if the name matches i need to compare the values
taylor has different values so we need to take the difference of the,
pradeep has same values so we can assign zero
where should we assign these values?
in a separate column
in which excel file?
in second excel