LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default CSV file conversion + True/False over multiple columns of data

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
True false function for alpha data R Y Excel Worksheet Functions 7 November 18th 09 02:57 PM
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 LunaMoon Excel Discussion (Misc queries) 9 July 29th 08 12:28 AM
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 LunaMoon Excel Programming 9 July 29th 08 12:28 AM
function help-keeping data from true when false jay d Excel Worksheet Functions 8 May 19th 06 01:44 PM
Displaying data based on a TRUE/FALSE value in a cell static69 Excel Discussion (Misc queries) 3 June 1st 05 07:09 AM


All times are GMT +1. The time now is 02:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"