Automate Excel Permutation Matching
Budget: ₹750 – ₹1,250 INR
I have an existing Excel workbook that holds all the source text I need analysed. What I want is a repeatable, push-button solution—either native formulas, Power Query, or a small VBA routine—that takes every string in my primary column, produces every possible permutation of the words, and then checks those permutations against the comparison list already sitting in another sheet.
The macro or formula set should return the exact matches next to the original record, flagging duplicates or near-duplicates only if they are true permutations, not simple substrings. A clear, well-commented approach is important because I will maintain this file after delivery.
You will receive the workbook immediately so you can see the current layout. Please outline briefly which Excel feature (dynamic arrays, LET/LAMBDA, Power Query, or VBA) you plan to use and why—it helps me keep future maintenance straightforward.
When you hand the project back I should be able to:
• Drop in new data, click a single button (or refresh), and get fresh results.
• Trace the logic easily through comments or a short read-me.
If you’ve tackled similar permutation or text-matching challenges before, that experience will be a huge plus.
The macro or formula set should return the exact matches next to the original record, flagging duplicates or near-duplicates only if they are true permutations, not simple substrings. A clear, well-commented approach is important because I will maintain this file after delivery.
You will receive the workbook immediately so you can see the current layout. Please outline briefly which Excel feature (dynamic arrays, LET/LAMBDA, Power Query, or VBA) you plan to use and why—it helps me keep future maintenance straightforward.
When you hand the project back I should be able to:
• Drop in new data, click a single button (or refresh), and get fresh results.
• Trace the logic easily through comments or a short read-me.
If you’ve tackled similar permutation or text-matching challenges before, that experience will be a huge plus.