
Ouvrir
Publié
•
Se termine dans 2 jours
I have a single Excel file holding fewer than 1,000 rows of mixed text and numeric fields. My aim is to identify and flag records that are not exact duplicates but close enough to be considered the same customer, product, or transaction. In other words, I need a reliable fuzzy-matching solution that surfaces these near-matches so I can review and consolidate them. Here is what I need from you: • A working Excel-based approach—formulas, Power Query, VBA, or a combination—that compares the mixed fields and returns a similarity score or direct match flag. • Clear, editable logic so I can tweak thresholds or add new columns later without rewriting the whole thing. • A brief walkthrough (written notes or short screen capture) showing how the matching was set up and how I can re-run it when new data arrives. If you have a preferred library, add-in, or custom function for fuzzy logic, feel free to use it as long as it’s included or clearly documented. Accuracy and transparency matter more than flashy visuals; I simply need to trust the matches and know how to maintain the workbook afterward.
N° de projet : 40275478
55 propositions
Ouvert aux candidatures
Projet à distance
Actif à il y a 1 jour
Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
55 freelances proposent en moyenne €10 EUR/heure pour ce travail

As someone with extensive experience in data analysis and processing, especially with Excel, I am confident that I can provide you with a reliable and efficient fuzzy matching solution for your dataset. My proficiency in Excel Formulas, VBA, Macros and coding useful scripts will enable me to create clear, editable logic that allows for flexibility in tweaking thresholds or incorporating new columns as per your need. Moreover, my exposure to different libraries and tools can result in a comprehensive approach that ensures accuracy without compromising on transparency. Being an employer-oriented professional, my primary objective is to ensure 100% client satisfaction by delivering high quality work with best possible speed. My past collaborations with top companies such as Metlife GOSC and DXC Technologies demonstrates my ability to consistently meet this goal. In addition, my offer of free 4-day support after project completion ensures that you will not be left stranded even after delivery. In conclusion, by choosing me for this project you are hiring not just the skills of a seasoned full stack developer but also the commitment to building long-term relationships and going above and beyond to make sure clients feel they've had their money's worth. Rest assured, I can provide you with a result-driven approach that doesn’t only solve your existing problems but also equip you with the necessary knowledge to maintain the workbook on your own.
€15 EUR en 40 jours
8,6
8,6

Hello! I'm an expert Excel and data matching specialist with over 9 years of experience building fuzzy logic solutions that uncover near-duplicates across customer, product, and transaction data. I know exactly how to surface those close-but-not-exact matches so you can review and consolidate with confidence. Here's how I can help: - Build a transparent fuzzy-matching solution using Excel formulas, Power Query, or VBA with a Levenshtein distance algorithm to compare mixed text and numeric fields - Return clear similarity scores or match flags for each record, with editable thresholds you can tweak anytime without touching the underlying code - Set up the logic in a clean, maintainable structure so you can add new columns or adjust matching criteria later - Provide a brief written walkthrough or screen capture showing exactly how the matching works and how to re-run it on fresh data I'll document every step so you trust the matches and can maintain the workbook yourself. Accuracy and transparency are my priority—no black boxes. To tailor the solution: which fields are most critical for identifying duplicates (e.g., customer name, product code, transaction amount)? And what similarity threshold feels right to start (e.g., 80% match)?
€9 EUR en 40 jours
7,3
7,3

Hello, I have carefully reviewed your requirements and fully understand that you need a reliable fuzzy matching solution within Excel to identify near duplicate customer, product, or transaction records. With strong expertise in Excel automation, VBA, and data cleansing, I can confidently deliver a transparent and maintainable solution. First, I will analyze your dataset structure and normalize key text fields using Power Query for trimming, casing, and standardization. Next, I will implement fuzzy matching using Power Query fuzzy merge functionality combined with a custom similarity scoring logic. Where needed, I will enhance accuracy using VBA with Levenshtein distance or Jaro Winkler based comparison to calculate similarity scores across mixed text and numeric fields. Then, I will design editable threshold controls so you can easily adjust match sensitivity or add new comparison columns without restructuring the workbook. All logic will be clearly organized and documented for long term usability. Finally, I will provide a concise walkthrough explaining the setup and how to rerun the matching process when new data is added. Would you prefer similarity scoring across selected key columns only, or a weighted composite score across all fields? Lets chat and discuss further! Best Regards, Aneesa.
€10 EUR en 40 jours
6,8
6,8

I can create an Excel-based fuzzy matching solution that flags near-duplicates with a clear similarity score and adjustable threshold. You’ll receive a transparent, easy-to-maintain workbook plus brief instructions to rerun it on new data. ,,,,,, 10+ years Advanced Excel & VBA experience, Certified VBA Programmer, MBA.
€10 EUR en 40 jours
6,5
6,5

Hello, I bring over 7 years of experience in Data Processing, Excel, Excel VBA, Excel Macros, Data Cleansing, and Visual Basic. I have carefully reviewed your requirement for implementing a fuzzy matching solution in Excel to identify and flag near-duplicate records. To achieve this, I propose to utilize a combination of Excel formulas and VBA coding to compare the mixed fields and generate a similarity score or direct match flag. The solution will be designed with clear and editable logic, allowing you to adjust thresholds or expand functionality in the future without major revisions. Furthermore, I will provide a detailed walkthrough document or video tutorial demonstrating the setup of the matching process and instructions on how to rerun it with new data. I will ensure the solution is accurate, transparent, and easy to maintain to meet your ongoing needs. I would like to discuss this project further in chat to understand your specific requirements and preferences. Please feel free to connect to explore this opportunity in more detail. You can visit my Profile: https://www.freelancer.com/u/HiraMahmood4072 Thank you.
€6 EUR en 40 jours
6,4
6,4

Hello, I’m an advanced Excel specialist experienced in building reliable fuzzy-matching solutions using Power Query, formulas, and VBA. For your dataset, I’ll implement a clear similarity scoring system with adjustable thresholds so you can easily control what counts as a near duplicate. The solution will be transparent, modular, and easy to maintain, with documented logic and a brief walkthrough showing how to adjust settings and re-run it when new data is added. Regards, Zafar
€6 EUR en 40 jours
6,2
6,2

Hi there, Myself suganya hope you are doing good. i am clear with the instruction and happy to identify and flag records that are not exact duplicates but close enough to be considered the same customer, product, or transaction. I have more than 6 years of experience in data processing . Good in handling digital documents in excel, pdf, word, etc... easily and quickly. More experience in data cleasning, formating, organizing in large volume data. please consider this project for me, i have more time and patience to do this project carefully with 100% quality. Confidently Waiting for you to discuss about this project please kindly check my efficiency and effort in all completed projects here, https://www.freelancer.com/u/suganyav12 BEST OF RECENT REVIEW FROM CLIENTS HERE, Great work - fast, professional, on point, great communcation. Will hire again! [24 February, 2026] Suganya understood the brief and went above and beyond to get the work done in a professional, speedy and prompt manner. Will definitely be hiring again for more work down the track. Thanks! Suganya’s work was precise and delivered at the highest level of quality. I wouldn’t hesitate to hire her again. Highly recommended. [08 February, 2026] Suganya’s work was precise and delivered at the highest level of quality. I wouldn’t hesitate to hire her again. Highly recommended. Thanks, suganya
€6 EUR en 5 jours
5,6
5,6

Hello I will create a clear, reliable Excel fuzzy-matching solution (Power Query and/or VBA similarity function) that returns a similarity score and match flag, with editable thresholds and transparent logic so you can easily adjust fields later. The workbook will include brief setup notes and simple steps to re-run it when new data is added. Regards Muhammad
€10 EUR en 40 jours
5,3
5,3

Hello, I can set up a **reliable Excel fuzzy-matching solution** for your file of under 1,000 rows. I will implement a combination of **Power Query and VBA**, optionally with a lightweight fuzzy logic function, to compare mixed text and numeric fields, returning a **similarity score or match flag** for near-duplicates. The logic will be fully editable, so you can tweak thresholds or add new columns without redoing the setup. I will provide clear documentation along with a short walkthrough (written notes or screen capture) showing how to re-run the matching when new data arrives. This ensures you can maintain, audit, and trust the results without needing external tools. 1. Should the match consider all columns equally, or weight certain fields (e.g., customer name vs transaction ID) higher? 2. Do you want the output in a new sheet highlighting suggested consolidations, or inline within the existing data? Thanks, Asif
€15 EUR en 40 jours
5,2
5,2

Hi, how are you doing? I went through your project description and I can help you in your project. your project requirements perfectly match my expertise. We are a team of experts with substantial background in ELECTRICAL and ELECTRONICS Engineering working on MATLAB programming and SIMULINK Modelling, we have successfully completed 1000+ Projects for multiple regular clients from OMAN, UK, USA, Australia, Canada, France, Germany, Lebanon and many other countries. We are providing our services in following areas: Digital Signal Processing | Filter design | Fourier analysis Image Processing | Object Detection | Image Segmentation | Feature Extraction Control systems | PID Controller design | Observer design Power Systems | AC-DC Hybrid Micro-grid | Fault detection | Energy Management Artificial Intelligence | Machine Learning | Python Neural Networks | ANFIS | Fuzzy logic Also, we have good command over REPORT WRITING, we can show you many samples of our previous reports. We can discuss further details in the message box.
€20 EUR en 40 jours
5,6
5,6

Excel VBA developer ready to do the required Excel Fuzzy Matching Setup. Check sample form my works and clients' reviews from links below. Regards . . https://www.freelancer.com/projects/excel/Excel-Auto-Execute-Macro-Upon/reviews https://www.freelancer.com/projects/data-processing/data-processing-use-mail-merge/reviews
€10 EUR en 40 jours
5,2
5,2

As a seasoned Data Analyst with a strong command on Excel and VBA, your project aligns perfectly with my skill set. I'll develop and deploy a reliable, transparent, and flexible fuzzy-matching solution using formulas, Power Query, VBA or a combination of all three that can compare rows based on mixed text and numeric fields in your excel file. My unique approach will grant you the freedom to tweak thresholds or add new columns without rewriting the whole solution. While refining data, I will maintain accuracy while ensuring visibility so that you can easily pinpoint which records are worth consolidating. While I understand that flashy visuals may not be the highest priority for you, I assure you that my work will not merely stop at providing an efficient matching accuracy; I'll go beyond to accompany it with a simple yet detailed walkthrough via screen captures or written notes to ensure future repeatability even when new data emerges. My expertise married with your vision will be the perfect recipe for streamlining your data and saving you invaluable time.
€9 EUR en 40 jours
3,5
3,5

Hello, I’ve reviewed your project and understand you need a reliable, maintainable fuzzy-matching solution in Excel for near-duplicate detection across mixed text and numeric fields. I’ve implemented similar solutions using VBA, Power Query, and custom formulas that return similarity scores, highlight matches, and allow threshold adjustments. I’ll provide fully editable logic, so you can tweak columns, thresholds, and add new data without redoing the setup. A concise walkthrough will show how the matching works and how to refresh it with new records. Looking forward to hearing from you. Thank you.
€12 EUR en 40 jours
3,4
3,4

Hi, I can build you a reliable Excel-based fuzzy-matching solution that flags near-duplicate records with a clear similarity score and adjustable threshold logic. Given your dataset is under 1,000 rows, I’d structure this using Power Query’s fuzzy merge (for scalable text similarity) combined with formula-based scoring and optional VBA only if needed for automation. You’ll get transparent, auditable logic where you can easily adjust match thresholds, weight specific columns (e.g., name vs. postcode vs. amount), and add new fields without breaking the model. I’ll also include concise documentation explaining the scoring methodology, how similarity percentages are calculated, and how to refresh or rerun the matching when new data is added. If helpful, I can record a short walkthrough demonstrating setup, threshold tuning, and consolidation workflow so you remain fully in control of the file moving forward. Regards Adnan
€12 EUR en 40 jours
3,2
3,2

With fewer than 1,000 rows, Excel can handle reliable fuzzy matching quite efficiently. I can build a solution that identifies near-duplicate customers, products, or transactions using a clear and maintainable approach so you can adjust it later without rewriting everything. The workbook can use a combination of Power Query fuzzy matching and supporting formulas (or VBA if needed) to compare the relevant fields and generate a similarity score or match flag. This will allow you to quickly spot records that are not exact duplicates but likely refer to the same entity. The logic will be structured so you can change similarity thresholds, add new columns to the comparison, or rerun the matching easily when new data is added. You’ll receive a working Excel file with the fuzzy matching setup, along with simple notes or a short walkthrough explaining how the logic works and how to rerun the process whenever your dataset is updated. Best Regards, Shabahat Habib...
€9 EUR en 40 jours
2,2
2,2

Hi there, I just read your posting. It sounds like you need an expert in cold emails to advise you on everything from the content to the overall strategy. I am a software engineer with 13+ years experience in email marketing . Cold emailing in B2B is what I specialize in. I can work with you to write the content and subject lines, recommend the best technologies for you to use, and more. Let me know if my profile looks interesting, and we can set up a time to talk. Best regards,
€30 EUR en 19 jours
0,0
0,0

Hello Sir, I have read your project carefully. You need accurate data entry work in Excel. I have good typing speed and experience in Excel formatting and data handling. I can complete your work with 100% accuracy and within deadline. I will double-check the data before submission to avoid errors. Looking forward to working with you. Thank you.
€9 EUR en 40 jours
0,0
0,0

I will implement a reliable Excel-based fuzzy matching solution using formulas, Power Query, or VBA, provide editable logic, similarity scores, and a clear walkthrough so you can maintain and update it confidently.
€8 EUR en 40 jours
0,0
0,0

Hi ? This is a nice clean task — and with under 1,000 rows we can make it both accurate and easy to maintain. I’d build this directly inside Excel using Power Query for preprocessing + either a fuzzy merge setup or a small VBA function for similarity scoring (Levenshtein-based). That way you’re not locked into some black-box add-in. You’ll get: • A similarity score column (0–100%) • A clear “Potential Match” flag based on a threshold you can adjust • Editable logic so you can tweak weights for name / number / product fields • Simple refresh process when new rows are added Everything will be transparent — you’ll see exactly how matches are calculated and be able to adjust thresholds without rewriting formulas. I’ll also include short notes (or a quick screen recording if you prefer) showing how to refresh and modify the setup. Clean, practical, and built so you can maintain it yourself.
€9 EUR en 100 jours
0,0
0,0

Hi! This sounds like a great little data-cleanup project, and I’d be happy to help. With fewer than 1,000 rows, we can build a solid fuzzy-matching setup in Excel that reliably flags near-duplicates—whether they’re similar customer names, slightly different product spellings, or small variations in transaction details. I can use Power Query’s fuzzy matching, formulas, or a clean VBA approach—whatever fits best—while keeping everything transparent and easy to adjust. I’ll make sure you can tweak similarity thresholds or add new fields without breaking the logic. You’ll also get a short explanation (or quick walkthrough) so you can confidently refresh it when new data comes in. Accuracy and clarity will be the focus.
€6 EUR en 50 jours
0,0
0,0

Vienna, Austria
Membre depuis janv. 31, 2026
€6-12 EUR / heure
$30-250 CAD
$250-750 CAD
₹12500-37500 INR
₹600-1500 INR
$10-70 USD
₹750-1250 INR / heure
$10-30 AUD
$30-250 USD
$30-250 USD
₹600-1500 INR
£5-10 GBP / heure
₹600-1500 INR
$10-30 AUD
$250-750 USD
₹1500-12500 INR
$250-750 USD
$30-250 USD
$10-30 USD
₹600-1500 INR
₹12500-37500 INR