ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   All variations of a set of numbers and letters (https://www.excelbanter.com/excel-discussion-misc-queries/91037-all-variations-set-numbers-letters.html)

Tim Mc

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

Jim Cone

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

Tim Mc

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


Jim Cone

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