• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Validating and Verification on 2 Spreadsheets

J

jgrimmer

New Member
Hello,
I am a Senior Business Analyst and have inherited a project containing 150,000 rows of data on two separate spreadsheet of different characteristics. I will try to explain this as best as I can in simple terms.

Spreadsheet #1 (Original)
Rows: Approx 150,000
Columns: Through AD that I need to use. Everything else is hidden.

Spreadsheet #2(Validation Sheet)
Rows: Approx 150,000
Columns: Through AD that I need to use. Everything else is hidden.

This needs to be done with 150,00 Rows

Constraints:
Multiple Columns of Bill Code on Original matching to one one Validation sheet
All Data Already Exists so it's Either Adding data to one column and a letter to another or just add a letter to one column if no match.

Need To Match on Color and Date in order to move to Provider and Bill Code
 

Attachments

  • Help Doc.xlsx
    10.6 KB · Views: 3
Last edited:
Ok, just reloaded some quick changes. It all might not makes sense with the changes but just look at the document and it will become clear
 
This may be more of a SQl query but everything is in Excel to begin with and I don't really feel like making copy tables in the SQL Database just for a hopefully one time validation. Same with Access. I am trying to make this as user friendly as possible for other workers I have below me that are not familiar with SQL or Access Queries.
 
You must log in or register to reply here.
Back
Top