Hey All,
I need help with a new formula, I have been using this Data for a while, but I put it in manually and that is getting old.
Im hoping that I explain this correctly so people will understand, I apologize if it's confusing. I will do my best to explain.
The Notes in the attachment should help with understanding my goal for the formula.
Ok, here it is.
I have 3 digit numbers 0-9 that will continue down Column(D) Examples are 432, 287, 165, 526, 580, 613, 631, etc.
These 3 digit numbers I will need to take and extract each individual digit and put in a row, the columns will be E-N and (labeled 0-9 in row 1)
I will need the formula to look at Seven of the 3 digit numbers at a time, it will count each individual digit and put in the row of the columns marked 0-9
Example from numbers above would go in Columns E-N marked 0-9 in row 8.
Note:
Column E is Marked "0"
Column F is Marked "1"
Column G is Marked "2" and so on until Column N which is Marked "9"
Below is how it works:
432, 287, 165, 526, 580, 613, 631
This would be: E8 is 1 because only one "0" is in the seven 3 digit numbers listed above
F8 is 3 because of three "1's" in the seven 3 digit numbers
G8 is 3 because of three "2's" in the seven 3 digit numbers.
and so on until
N9 which is "0" because of no "9's" in the seven 3 digit numbers
If you add the Row 8 Columns E-N together you will get 21 which is the seven 3 digit numbers (7 times 3 = 21)
Once a new 3 digit number arrives after the 631 from numbers above i will need to take away the first number which is (432) from the formula (But leave it in place on my excel sheet)
So the new seven 3 digit numbers will be 287, 165, 526, 580, 613, 631, 355
Row 9 will show just like the above example except leaving the 432 out and adding the 355
This same pattern will continue
I have faith that this forum and the experts will figure this out for me.
I'm learning more and more everyday with formulas in excel. I used excel for years putting in numbers manually not knowing anything about formulas until recently and it has changed my world.
Thanks in advance,
Brian
Bookmarks