Forum Discussion
Help for formula for extracting different words and sorting them among spreadsheet
Hello all, I need a specific formula. I've search a lot on internet, found way more complicated requests but not this one. I will be typing different words in different cells and columns. Some...
If name the source as range
that could be
=LET(
n, ROWS(range),
m, COLUMNS(range),
k, SEQUENCE(n*m),
rN, INT( (k-1)/m)+1,
cN, MOD(k-1,m)+1,
all, LET( t, INDEX( range, rN, cN), FILTER(t, t<>"")),
list, UNIQUE(all),
count, MMULT(--(list=TRANSPOSE(all)), SEQUENCE(ROWS(all),,1,0) ),
IF({1,0}, list, count) )
- Where you put this code?
