Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Okay I've been lurking for a few days looking through some threads trying to find out a way to accomplish the task I want.
Thru a SQL comparison tool, I've got about 20 tables of data to compare test and production environments. These files are output as a .csv file. I might have anywhere from 10 to 240 columns of data that is in the .csv file. What I'd like to know if it's possible: Take the .csv file, import it into Excel 2010 with columns using the commas as a separator, and then have a True/False script run that will then cleanup the data and only show me the data if Column A does not match what Column B has. Optional: Add a color highlight to match the side by side columns, aka light blue for Column A/B, light yellow for Columns C/D, all the way to the end. As a heads up, this is not my primary job role, and programming is something my experience is very, very light. Any points in the right direction or links to other threads I might have overlooked would be greatly appreciated. I can provide any sample files if necessary both in terms of source files and the desired output. Thank you all ahead of time for any and all direction or assistance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
True false function for alpha data | Excel Worksheet Functions | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Programming | |||
function help-keeping data from true when false | Excel Worksheet Functions | |||
Displaying data based on a TRUE/FALSE value in a cell | Excel Discussion (Misc queries) |