Xlambda
Well-known Member
- Joined
- Mar 8, 2021
- Messages
- 833
- Office Version
- 365
- Platform
- Windows
AANAGRAM finds anagrams matches between 2 arrays. calls AKEEP , T_CHARS ,ATEXTJOIN , AUNQSRT
Excel Formula:
=LAMBDA(a,b,
LET(x,AKEEP(a,T_CHARS(,2,),),y,AKEEP(b,T_CHARS(,2,),),
z,ATEXTJOIN(AUNQSRT(MID(x,SEQUENCE(,MAX(LEN(x))),1),1),,,),v,ATEXTJOIN(AUNQSRT(MID(y,SEQUENCE(,MAX(LEN(x))),1),1),,,),
IFNA(XMATCH(z,v),"-")
)
)| LAMBDA 7.0.xlsx | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 1 | D3 | =ATEXTJOIN(F3:F9,SEQUENCE(ROWS(F3:F9))&"-",,) | ||||||||
| 2 | array a | =AANAGRAM(A3:A11,F3:F9) | array b | |||||||
| 3 | Stereophonics | 2 | 1-Hairy Camera | Hairy Camera | ||||||
| 4 | Mariah Carey | 1 | 2-Shoe Inspector | Shoe Inspector | ||||||
| 5 | Abbab | - | 3-Rain Van | Rain Van | ||||||
| 6 | Is it a rum | 6 | 4-See Ace Heck | See Ace Heck | ||||||
| 7 | Baba | 7 | 5-Open at ten | Open at ten | ||||||
| 8 | Nirvana | 3 | 6-Tiramisu | Tiramisu | ||||||
| 9 | Panettone | 5 | 7-Abba | Abba | ||||||
| 10 | Cheesecake | 4 | ||||||||
| 11 | Net at open | 5 | ||||||||
| 12 | ||||||||||
AANAGRAM post | ||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D1 | D1 | =FORMULATEXT(D3) |
| B2 | B2 | =FORMULATEXT(B3) |
| B3:B11 | B3 | =AANAGRAM(A3:A11,F3:F9) |
| D3:D9 | D3 | =ATEXTJOIN(F3:F9,SEQUENCE(ROWS(F3:F9))&"-",,) |
| Dynamic array formulas. | ||
Upvote
0
