Compare Range?

[fairymemay (noona)]

Compare range in excel

Hello again @fairymemay, Find attached the new solution. I had to add one extra column in the Config_rate sheet: [image] It must match the respective column in the summary sheet. [image] It is taking around 20 seconds to run the process If you have any question, let me know. If it solves your problem, kindly mark this post as solution to close this topic. Thanks! Main.xaml (38.9 KB)

@gustavo.cervelin From previous forum If I want edit file config as below.

If in column APPLAN found value in column Campaign -----> Look rate in column Special Rate & Special Rate2

But If value in column APPLAN not found in column Campaign -----> Look rate in column Other Rate & Column Other Rate2.

Please guide me about it.
ConfigRate_Bag (2).xlsx (20.9 KB)

Input (9).xlsx (452.5 KB)
Main.xaml (42.4 KB

[varunk (Varun Kumar)]

Try with linq query it will be easy to compare

[fairymemay (noona)]

@varunk How to edit this flow?

Main.xaml (42.4 KB)

[gustavo.cervelin (Gustavo Cervelin Custódio)]

Hi @fairymemay,

Please, take a look at the attached file.

Note: You can delete that column “Summary Column”. It’s not necessary.

Main.xaml (43.6 KB)

If this solves your problem and you agree, kindly mark this post as solution to close this topic.

If you need extra help and/or have any question, please let me know

Thanks!