Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of individual digits (just for fun)
I want to sum how often a certain digit (for example 1) appear in
the in the sequence of whole numbers 1, 2, ,...., N N 1 10 11 21 .... f(N) 1 2 4 13 .... N=21 --- f(N)= number of ones in {1, 10, 11, 12, 13, 14 ,15 ,16, 17 ,18, 19, 21}=13 I have mmade an attempt with the following array formula: =CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A11))),1)) which for N=1 returns 49, for N=10 returns {49,48} and so on. How can I extend above formula (count the "49's") so that I get the results shown under f(N) or maybe a better way? Hans Knudsen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
maximum number size/significant digits | Excel Discussion (Misc queries) | |||
Mistery digits on excel | Excel Discussion (Misc queries) | |||
excel floating digits error | Excel Discussion (Misc queries) | |||
Count individual digits | Excel Discussion (Misc queries) | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) |