Comparing two excel column

excel
activities

#1

Hello,

I’m trying to use a formula: row.Item( Firstcolumn as string )=row.Item(SecondColumn as string) in if statement but it return:


#2

@abdel

Try like this
row.Item( “Firstcolumn Name” ).ToString.Equals(row.Item(“SecondColumn Name”).ToString

Regards,
Mahesh


#3

thank you,

another question i had to read a range  for ex "A4" to "C34" but the lenght is varying, did "A4:C34" working?

#4

Yes A4:C34 will work


#5

and if i need to check if it is not equal?
in fact, i have an excel sheet and i need to check in 1 column if there is a special character “?” and return the value of the corresponding cell in another column column2 and for the end shows all the values in one other columns