Excel Project (can be done using Excel Macros or any other program)
Budget: ₹1,500 – ₹12,500 INR
Hi,
I have to compare 2 files and find out the difference between the two. I require only the difference (greater than 1 OR lesser than -1) and the if any #NA values.
All i will do is upload the two files in the same format and then get the output via the macro or any other software.
Please note i want to compare file 1 to file 2 AND file 2 to file 1 both ways.
I have tried a way to do it but i want to only upload 2 file and get the difference.
https://www.youtube.com/watch?v=r8490EbFkF4
Real Data will be bigger than this, so it should be optimized to run with bigger data.
I have to compare 2 files and find out the difference between the two. I require only the difference (greater than 1 OR lesser than -1) and the if any #NA values.
All i will do is upload the two files in the same format and then get the output via the macro or any other software.
Please note i want to compare file 1 to file 2 AND file 2 to file 1 both ways.
I have tried a way to do it but i want to only upload 2 file and get the difference.
https://www.youtube.com/watch?v=r8490EbFkF4
Real Data will be bigger than this, so it should be optimized to run with bigger data.