LinkBack URL
About LinkBacks
example
Cell A5 is AAB, 1+1=2=4, answer is 4
Cell A9 is EE, 5+5=10, answer is 10
Can someone please help me ? It would be much appreciated. Thanks in advance
example
Cell A5 is AAB, 1+1=2=4, answer is 4
Cell A9 is EE, 5+5=10, answer is 10
Can someone please help me ? It would be much appreciated. Thanks in advance
Last edited by choletseng; 04-29-2024 at 08:40 AM.
Remove ALL expected results and paste this into B5:
=LET(d,A5:A9,BYROW(d,LAMBDA(r,LET(s,MID(r,SEQUENCE(,LEN(r)),1),SUM(REDUCE(0,s,LAMBDA(x,y,HSTACK(x,FILTER(B2:F2,B1:F1=y)))))))))
Last edited by AliGW; 04-29-2024 at 08:21 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Pls Remove B5:B9 , Cell B5 formula
Formula:
Please Login or Register to view this content.
Another optionFormula:Please Login or Register to view this content.
You are all amazing, thank you for all help
Pleasure!
Glad to help & thanks for the feedback.
choletseng You're Welcome. Glad to help . Thank You for the feedback and rep.
Another approach... (Without defining table and assuming A-Z 1 to 26 corresponding)
=SUM(IFERROR(UPPER(CODE(MID(A5,ROW($A$1:$A$30),1))),64)-64)
Last edited by zbor; 04-29-2024 at 09:14 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks