Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying decimals that go in to a given number
Hi Guys,
I might be asking for a bit to much, but i thought id give it a go anyways. What i want to do is display what number(s) 'go in to' a given number. For example, Sheet1 Cell A1 displays the figure "10" Using a macro or whatever is easiest, Id like to write the numbers that go into the figure "10" into Cells on Sheet2, starting at A1. eg, Sheet1 Cell A1 displays the figure "10", find what goes into this number. In Sheet2, Cell A1 = "1" Sheet2, Cell A2 = "2" Sheet2, Cell A3 = "5" As it was smart enough to work out that the whole factors 1, 2 and 5 all can make up the figure 10. The max amount of digits ill use is 4 (eg, 1000 - what goes into 1000?) I guess the easiest way to explain this, is: "what numbers go into 10. once you have that number set, id like you to display each individual number into a seperate cell on the following sheet" I figure its a big ask, so i thankyou in advance!!! Cheers, Steve. PS: ill be doing a vlookup on these numbers then matching them with other data in corresponding cells, which is easy enough to do. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying decimals that go in to a given number
See:
http://groups.google.com/group/micro...87d751e5d179d9 -- Gary''s Student "weSky" wrote: Hi Guys, I might be asking for a bit to much, but i thought id give it a go anyways. What i want to do is display what number(s) 'go in to' a given number. For example, Sheet1 Cell A1 displays the figure "10" Using a macro or whatever is easiest, Id like to write the numbers that go into the figure "10" into Cells on Sheet2, starting at A1. eg, Sheet1 Cell A1 displays the figure "10", find what goes into this number. In Sheet2, Cell A1 = "1" Sheet2, Cell A2 = "2" Sheet2, Cell A3 = "5" As it was smart enough to work out that the whole factors 1, 2 and 5 all can make up the figure 10. The max amount of digits ill use is 4 (eg, 1000 - what goes into 1000?) I guess the easiest way to explain this, is: "what numbers go into 10. once you have that number set, id like you to display each individual number into a seperate cell on the following sheet" I figure its a big ask, so i thankyou in advance!!! Cheers, Steve. PS: ill be doing a vlookup on these numbers then matching them with other data in corresponding cells, which is easy enough to do. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count each cell that have a number and take that number and count. | Excel Discussion (Misc queries) | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions |