
Closed
Posted
Paid on delivery
I need help comparing two data sets within the same Excel file. The goal is to identify matching records based on special text patterns or values. Requirements: - Access to Excel with two sheets - Identify matching records using custom criteria Ideal Skills: - Excel proficiency - Experience with data comparison tasks - Attention to detail
Project ID: 40783199
20 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
20 freelancers are bidding on average ₹20,589 INR for this job

Youssef, Full-Time Python Developer, specialized in Excel data comparison and matching records. Two sheets, custom text patterns, one clean output: I would read both sheets with pandas, apply your matching criteria as explicit rules, and write the flagged matches back to a new sheet. I'd check first how your patterns vary between records, since a few real examples settle the matching logic faster than guessing. I've shipped similar Excel comparison and record matching work before. Can you share the file or two sample rows showing what counts as a match? Ready to start immediately.
₹17,075 INR in 1 day
7.2
7.2

Accurate Excel data comparison is one of my core strengths, supported by hands-on experience with functions, formulas, formatting, pivot tables, charts, and data processing. I can work across two sheets in the same workbook and identify matching records based on your specific text patterns or values with careful attention to detail. My background in numeric and text-based data entry, data analysis, data mining, and collection helps me handle records systematically while keeping the results clear and reliable. I also work with the latest versions of Microsoft Excel and provide precise, professional support with fast delivery. Choose me for a careful and dependable comparison of your Excel data, and I will ensure the matching records are identified accurately.
₹15,000 INR in 1 day
6.5
6.5

Hello! I can help compare the Excel data and identify matching records based on your specific text patterns or values. I have checked the attached file and can see data in columns B-M, with some empty cells. However, I could only identify one worksheet in the file. Could you clarify the matching criteria and explain what the two data sets should be compared against? Once the comparison rules and data sources are clear, I can determine the appropriate approach and provide accurate results.
₹15,000 INR in 2 days
6.3
6.3

Hi, I'd be glad to help compare your two datasets in Excel and accurately identify matching records based on your custom text patterns and values. My approach begins with auditing the structure of both sheets in your workbook to inspect the exact variations in text formatting, leading/trailing spaces, and field delimiters. I will implement clean matching logic using tailored Excel formulas or Power Query transformation steps—handling partial strings, pattern extractions, and key identifiers without altering your source data. In previous data workflow projects, I structured complex Excel reconciliation models that systematically flag exact matches, partial pattern hits, and discrepancies into dedicated review columns with automated summaries. I can cover: • Thorough audit and cleanup of target text fields across both sheets • Implementation of custom pattern-matching rules and dynamic formula identifiers • Clear reconciliation output columns flagging match types and exceptions • Summary dashboard sheet showing match rates, duplicates, and unmatched records • Clean, documented Excel workbook ready for immediate reporting I work methodically to ensure complete data integrity with zero missed edge cases. Are the text pattern matches based on exact partial substrings, standardized codes, or fuzzy variations like differing abbreviations and typos? Best regards, Gagan
₹13,500 INR in 5 days
4.1
4.1

I can compare the two Excel datasets and identify matching records using your specific text patterns, values, and custom criteria. My approach will be to first inspect both sheets, understand the matching rules, and account for issues such as extra spaces, inconsistent text formats, duplicate records, or partial matches where relevant. I’ll then implement the most suitable solution using Excel formulas, Power Query, or Python, depending on the workbook’s structure. The deliverable can include: - Matching records identified across both sheets - Unmatched records flagged for review - Clear status indicators and a comparison summary - Validation checks to improve accuracy and make the results easy to verify My proposed bid is ₹20,000, with an estimated delivery time of 2–3 days, subject to reviewing the matching criteria and data volume. A few questions: 1. Could you share examples of the special text patterns or matching rules? 2. Should matching be exact, partial, or based on multiple columns? 3. How many records are in each sheet, approximately? 4. Would you prefer the results in the existing workbook, with matched and unmatched records highlighted, or in separate output sheets? I can begin as soon as the requirements are confirmed. Please feel free to review my Freelancer profile for my relevant data analysis and reporting experience.
₹20,000 INR in 7 days
4.1
4.1

Hi! I can compare both Excel sheets and identify matching records using your custom text patterns, values, or combinations of columns. I’ll create a reliable comparison that highlights exact matches, partial or pattern-based matches, and records that appear in only one sheet. I can also flag duplicates and handle differences such as extra spaces, inconsistent capitalization, or formatting where required. Depending on your workbook, I can use Excel formulas, Power Query, or Python to make the process accurate and easy to repeat. **Deliverable:** An updated Excel file with matching records clearly identified, unmatched records flagged, and a summary of the results. If needed, I’ll also include a simple refreshable workflow for future comparisons. Please share your Excel file and explain the special matching criteria or provide a few examples of records that should match. I’ll then recommend the most suitable approach.
₹25,000 INR in 7 days
0.0
0.0

I see you're looking to compare two data sets in Excel to identify matching records based on specific text patterns or values. This task requires precision and a good understanding of Excel functions. I can help streamline the process using formulas or conditional formatting to highlight matches effectively. By focusing on your custom criteria, we can ensure that nothing is overlooked. Could you share the specific text patterns or values you're looking for? This will help me understand how to approach the comparison best.
₹19,150 INR in 7 days
0.0
0.0

New Delhi, India
Payment method verified
Member since Oct 23, 2026
$250-750 USD
$30-250 USD
₹12500-37500 INR
₹750-1250 INR / hour
$1500-3000 USD
$30-250 SGD
₹12500-37500 INR
₹1500-12500 INR
₹1500-12500 INR
$15-25 USD / hour
$750-1500 USD
$30-250 USD
₹750-1250 INR / hour
£250-750 GBP
$250-750 USD
$2-8 USD / hour
$250-750 USD
₹12500-37500 INR
₹750-1250 INR / hour
$250-750 USD