problem calculating psychomatrix in excel ??

i tried to calculated psycho matrix in excel based data but im confusing how to make it in excel

For example the date of birth in cell e3-f3 : 05/12/1979 - (December 5, 1979.)
1) Add the digits of the day and month of birth: 5 +1 +2 = 8.
2) Add the digits of the year of birth: 1+ 9+ 9+ 7 = 26.
3) Add the resulting numbers: 8+ 26 = 34 - here we have the first working number.
4) Add the digits of the first working number: 3 + 4 = 7 - here we have a second working number.
5) From the first working number we are subtracting the doubled first digit of the date of birth:
34-2 * 5 = 24 - here we have the third working number.
6) Add the digits of a third working number: 2 + 4 = 6 - here we have a forth working number.

The first series of numbers: 5121979
The second series of numbers: 347246

After counting how many digits are there in both rows, we can form the table:
11 ... 44 ... 77
22 ... 5 ... No 8
3 ... 6 ... 99

the table data will appear in cell C30 - E32 in my excel like
cell c30 = count how many 1s
cell c31 = count how many 2s
cell c32 = count how many 3 s
cell d30 = count how many 4s
cell d31 count how many 5s
cell d32 = count how many 6s
cell e30 = count how many 7s
cell e31= count how many 8s
cell e32 count how many 9s

cross posting
https://www.excelguru.ca/forums/show...atrix-in-excel

Originally Posted by JohnTopley

See attached:

I used a simple series of MID/LEFT/RIGHT function to obtain the data: results in B43

in C30:

=LEN($B$43)-LEN(SUBSTITUTE($B$43,1,""))

Change 1 to 2,3 ... for other cells


Little confused by "Day" of birth as you have a MOD function for cell D3?

Birthday 17/06/1979

for 1. do we add 1+7+ 6 ?



so from above this 1 or 7?

Might need changes so I'll await your reply.

For testing set B43 5121979347246 and use the formula given above in C30

yeah we add 1+7+6
in cell C30 : E32 i mean not count like 1+1 = 2
but like find 1s series
example 5121979347246 ( final result after add 5121979 + 347246)
then we sort the value in C30:E32)
11 44 77
22 5 -
3 6 99

we count how much 1s appear,2s etc.
I mean not counting but taking the same value
take a certain value based on the final result after all calculating finished

Rule 08: Cross-posting Without Telling Us

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

No further help to be offered, please, until the OP has complied with this request.