Hi,
I am looking for a script to decompose a list of numbers into their prime factors.
Attached is a file with an example of what I am looking for.
Thanks for your help,
A.............B
56.......2 * 2 * 2 * 7
22.......2 * 11
36......2 * 2 * 3 * 3
84......etc
236.....
457.....
826.....
Decomposition in prime factor
I have a list of numbers in column A
I need a script that would decompose these numbers in prime factors
The result should appear in column B
Same question as here?
http://www.excelforum.com/excel-prog...me-number.html
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
A Google search would have given you the solution immediately without having to post twice on this forum
cant find answer
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks