Excel Data Comparison with Visuals

$2-8 USD / hour

Posted 1 minute ago

•

Ends in 6 days

$2-8 USD / hour

I have two Excel workbooks that hold similar datasets. I need a clean, automated comparison of every record using the unique ID/code column as the key. The goal is to see, side-by-side, what exists in one file but not the other, flag any rows that appear more than once, and then wrap everything up in a concise visual summary. Here is the exact scope I have in mind: • Read both workbooks, match rows solely on the unique ID/code. • Generate three clear tables:  1. Items present in File A but missing in File B.  2. Items present in File B but missing in File A.  3. Items that occur more than once in either file (show counts). • Create a summary sheet that lists total counts for each of the above and embeds an easy-to-read chart (bar or pie is fine) so the results can be grasped at a glance. • Keep the solution native to Excel—Power Query, formulas, or VBA are all acceptable so long as the file remains portable and the refresh process is straightforward. No external add-ins please. Deliver the finished workbook with all comparison logic in place plus a brief note explaining how to refresh or extend the checks if new rows are added later.

Project ID: 40813849

About the project

16 proposals

Open for bidding

Remote project

Active 4 secs ago

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

16 freelancers are bidding on average $7 USD/hour for this job

User Avatar
Flag of BANGLADESH

Hi, I have read the job description and now ready to start. I will provide 100% quality leads. Please send me a message for discussion. Let's discuss the job. Thanks

User Avatar
Flag of INDIA

Accurate Excel reconciliation is the foundation of a useful comparison report, and Excel is one of my core skills. I can create a clean workbook that matches both datasets by their unique ID/code, identifies records missing from either file, and highlights duplicate IDs with their occurrence counts. My software engineering background supports a structured, reliable solution while keeping the workbook native to Excel and free from external add-ins. I can also build the summary sheet with the requested totals and an easy-to-read chart, ensuring the results are clear at a glance and practical for ongoing use. I will deliver the comparison logic, visual summary, and a concise refresh note so the workbook can be updated when new rows are added. Choose me for an efficient and user-friendly Excel comparison solution.

User Avatar
Flag of INDIA

Hi, This is a clean fit for Power Query, so the whole comparison refreshes with one click and stays native to Excel with no add-ins: - Load both workbooks as queries, trimming spaces and standardising case on the ID/code column so near-identical IDs still match - A left anti-join gives Items in A not in B, and a right anti-join gives Items in B not in A - A Group By on the ID in each file gives the duplicates table with occurrence counts - A Summary sheet with the three totals and a bar chart that updates on refresh - File paths set in one parameter cell, so pointing the workbook at new files takes seconds - A short note on how to refresh (Data > Refresh All) and how to add more checks later I have experience in this type of work: I built an operational data dashboard and a clinical supervisor database for clients, so matching records on keys and turning the results into clear summaries is familiar to me. I can deliver the finished workbook within a day of receiving the two files. Which column holds the unique ID in each file? Best regards, Ankit

User Avatar
Flag of TAIWAN

Hi, I read your project "Excel Data Comparison with Visuals". I'm a senior engineer (11+ yrs) specialized in workflow automation (n8n / Make / custom Python) and API integration, which is exactly what this needs. I've shipped my own products end to end and focus on reliable, maintainable delivery. How I'd approach it: 1) Confirm the exact scope and edge cases with you 2) Build in small, testable steps so you see progress early 3) Clean handover with docs I can start right away. Happy to answer any questions. Best, Chris

User Avatar
Flag of UNITED ARAB EMIRATES

Excel data comparison and visualization aligns directly with my skills in Data Analysis, Data Processing, Data Visualization, Excel, Excel Macros, and Visual Basic. With a PhD in Artificial Intelligence and nearly 20 years of experience in software engineering, automation, and technology leadership, I can create a reliable native-Excel workbook that compares records by unique ID and presents the results clearly. I can implement the three required comparison tables for missing records in each file and duplicate IDs with counts, supported by automated Excel logic using Power Query, formulas, or VBA. The summary sheet will consolidate the totals and include a clear chart for quick interpretation, while keeping the workbook portable and straightforward to refresh when new rows are added. I will also include a concise refresh and extension note within the delivered workbook. My background in automation, data analysis, Excel macros, and Visual Basic makes me well suited to deliver a clean, maintainable comparison solution. Choose me to build this workbook with the comparison logic and visuals fully in place.

User Avatar
Flag of UKRAINE

Hi there, Which workbook structure should be treated as the source of truth if the ID/code appears in both files with different row data? Should the summary chart be based on unique IDs only, or on total duplicate occurrences too? The main task is to compare two workbooks by a single key, then produce clean exception lists and a compact summary sheet. A good fit here is Power Query for import and matching, with formulas or VBA only where a refresh button or final formatting makes the file easier to use. One risk is duplicate IDs hidden inside otherwise valid data, which can distort the missing-item counts if the comparison is done only row by row. That is best handled by building a keyed table first, then grouping by ID to flag duplicates before generating the three result tables. The finished workbook can stay fully native and portable, with refresh steps kept simple so new rows are picked up without rework. A short handoff note can explain how to refresh queries, update source ranges, and extend the checks if the column layout changes later. Best, Hlib

User Avatar
Flag of ARGENTINA

Hello, The important detail in this comparison is handling duplicate IDs separately from missing records. Otherwise, repeated entries can distort the comparison and make the final results misleading. I'd recommend using Excel Power Query for this task because it provides a reliable, refreshable solution without external add-ins or complicated VBA dependencies. I'd structure both workbooks as Excel tables, normalize the ID/code fields, and use anti-joins to identify records present only in File A or File B. Separately, I'd group records by ID in each source to identify duplicates and calculate their exact occurrence counts. The output workbook would contain three clearly structured comparison tables and a dedicated summary dashboard showing totals, key findings, and an easy-to-read chart. I'd also make the solution refreshable when new rows are added, without requiring changes to the underlying comparison logic. Before delivery, I'd test matching IDs, missing records, duplicate entries, blank values, and newly added rows to ensure the results remain accurate. I'll include a short usage guide explaining how to refresh the queries and extend the checks when your datasets grow. One question: Do both workbooks use the same column structure apart from their different records? Best regards, Nicolas

User Avatar
Flag of INDONESIA

Comparing your two Excel workbooks by their ID/code column and adding a visual summary is work I can do for you. I can keep it fully native to Excel, with no add-ins, so the file stays portable. I'll stay on it until the workbook runs cleanly on your real files and you're happy with it. Roughly how many rows does each workbook have? Happy to go through the details in chat whenever suits you. Sela

User Avatar
Flag of PAKISTAN

Hi, Comparing on the unique ID/code alone keeps the logic clean, and flagging duplicates with counts will make the gaps easy to spot. I would build this with formulas or Power Query so the workbook stays portable with no add-ins, and the summary chart will update as the data changes. Would both workbooks follow the same column layout, or do the ID fields differ in name or format between files? https://www.freelancer.com/portfolio-items/11574656-seo-blog-article-for-industry-topic Happy to hop on a quick chat to go over the details. Alyan

User Avatar
Flag of SOUTH AFRICA

I HAVE RECENTLY FINISHED A SIMILAR PROJECT where I automated data comparisons in Excel for a client, creating clear visual summaries. This involved matching records based on unique IDs, which is essential for your needs. I understand you're looking for an efficient way to compare datasets while ensuring everything is presented neatly. The requirement for a summary sheet with easy-to-read charts really emphasizes the importance of clarity in your data analysis. My approach centers on leveraging Excel's native capabilities, ensuring the solution is both functional and user-friendly, focusing on clean visuals and seamless data refresh processes. With my skills in Excel formulas and Power Query, I can deliver a robust workbook that meets your specifications. Let’s discuss your project further to clarify any specific details and ensure I capture your vision perfectly. Regards, Jeandre.

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

把喜欢的内容,留在你的新标签页。

打开我的订阅