LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default List number of permutations for text nums

I've got 4 digit text nums in A1 down
In B1 down, I would like to list the corresponding number of permutations,
eg:

7777 1
1777 4
0044 6
2477 12
1234 24


Game for any formula, udf or other vba solution
Thanks for insights


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Identify text nums in scrambled fashion Max Excel Discussion (Misc queries) 3 November 11th 09 10:45 PM
List of Permutations when 2 letter is taken at a time Prem Excel Discussion (Misc queries) 5 May 21st 08 07:04 PM
List of Permutations Prem Excel Discussion (Misc queries) 1 May 21st 08 09:19 AM
permutations of six digit number steed800 Excel Discussion (Misc queries) 4 October 5th 07 09:39 PM
Number permutations cassian New Users to Excel 1 August 8th 06 10:17 PM


All times are GMT +1. The time now is 04:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"