![]() |
All variations of a set of numbers and letters
Hi.
Does Excel has a formula that will display all variations of a set of numbers or letters eg AAB97 would contain AAB97, AAB79, ABA97 etc etc? Appreciate any help. Tim |
All variations of a set of numbers and letters
There is the free Excel add-in "Display Word Permutations" at my website
that will do that for up to 8 characters. Download from... http://www.realezsites.com/bus/primitivesoftware -- Jim Cone San Francisco, USA "Tim Mc" wrote in message Hi. Does Excel has a formula that will display all variations of a set of numbers or letters eg AAB97 would contain AAB97, AAB79, ABA97 etc etc? Appreciate any help. Tim |
All variations of a set of numbers and letters
Awesome add-in ... thanks Jim.
"Jim Cone" wrote: There is the free Excel add-in "Display Word Permutations" at my website that will do that for up to 8 characters. Download from... http://www.realezsites.com/bus/primitivesoftware -- Jim Cone San Francisco, USA "Tim Mc" wrote in message Hi. Does Excel has a formula that will display all variations of a set of numbers or letters eg AAB97 would contain AAB97, AAB79, ABA97 etc etc? Appreciate any help. Tim |
All variations of a set of numbers and letters
Tim,
You are welcome. Jim Cone "Tim Mc" wrote in message... Awesome add-in ... thanks Jim. "Jim Cone" wrote: There is the free Excel add-in "Display Word Permutations" at my website that will do that for up to 8 characters. Download from... http://www.realezsites.com/bus/primitivesoftware Jim Cone San Francisco, USA "Tim Mc" wrote in message Hi. Does Excel has a formula that will display all variations of a set of numbers or letters eg AAB97 would contain AAB97, AAB79, ABA97 etc etc? Appreciate any help. Tim |
All times are GMT +1. The time now is 02:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com