A program I can run large excel files to identify certain values
$30-250 USD
Completed
Posted almost 7 years ago
$30-250 USD
Paid on delivery
I think this is pretty simple but I cannot figure it out. I want a program that I can run large excel files through. I want the program to compare a given cell (A1) to another cell in that same row (B1) and identify if all of the characters contained in A1 are also contained in B1. If all characters ARE in A1 are also contained in B1 then do nothing. If all characters in A1 are not contained in B1 the highlight the entire row red. I want the program to work its way through the file comparing A2 to B2, A3 to B3 and so forth. Then of course I would want to get an out file that has accurately identified (highlighted in red) every instance where all of the characters in the first cell and not contained in the cell it is being compared to. Below is a small example of what the out file would look like.
hello
we need to discuss about solution there are many ways to comparing excel files like comparing cells with csv or by uploading in a sql based database so we can discuss it in PM
Stay tuned, I'm is still working on this proposal.
I can do this in about an hour, have been working with Excel generation for C# for years.
Relevant Skills and Experience
C#, Excel Generation
Proposed Milestones
$70 USD - Full project milestone
I'll provide you a console application. Let me know if you have any preference.