Alphanumerisation, Numérologie. Formules à rallonge

Bonjour à tous,

voici un tableur d’alphanumérisation pour faire de la numérologie par exemple.

alphanumerics.xlsx (215,0 Ko)

J’ai des formules à rallonge, du coup je me suis limité à 53 caratères. Une bonne âme serait elle comment rendre le calcul plus large en évitant ces formules indigestent.

Merci

Exemple cellule BA2:

=SUM(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($A2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($C2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($D2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($E2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($F2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($G2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($H2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($I2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($J2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($K2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($L2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($M2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($N2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($O2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($P2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($Q2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($R2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($S2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($T2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($U2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($V2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($W2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($X2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($Y2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($Z2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AA2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AB2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AC2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AD2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AE2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AF2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AG2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AH2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AI2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AJ2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AK2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AL2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AM2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AN2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AO2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AP2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AQ2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AR2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AS2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AT2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AU2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AV2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AW2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AX2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AY2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))+(IFERROR(INDEX($alphanumerics.CA$1:$alphanumerics.CA$50;MATCH($AZ2;$alphanumerics.$CM$1:$alphanumerics.$CM$50;0));0))

:tired_face:

Ce sujet a été automatiquement fermé après 30 jours. Aucune réponse n’est permise dorénavant.