problem calculating psychomatrix 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