Comparing two excel

Help
, ,
1

Am comparing two excel files. In one excel file one column value as 1.00 , comparing this with another excel file it has column value like 1, logically it rights, but it gives doesnt matched.
What data type should i give it to it???

2

Hi @Bakia_Murugesan

convert either the 1.00 to integer or the 1 to a double

That should allow you to match the files

1 Like
3

@Bakia_Murugesan

Cdbl(row1(“ColumnName”).Tosting) = Cdbl(row2(“ColumnName”).Tosting)

2 Likes
4

Thank you …Its working @lakshman

1 Like
5

Hi @Bakia_Murugesan

Here is a detailed article on that :slight_smile:

Regards,