excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi, how to add in the formula isblank for ignoring blanks?
Cell Formulas | ||
---|---|---|
Range | Formula | |
A2:L2 | A2 | =A1:L1 |
A3:G3 | A3 | =LET(t,VSTACK(G1:M1),r,ROWS(t),s,SEQUENCE(r*COLUMNS(t),,0),rs,MOD(s,r)+1,cs,INT(s/r)+1,i,INDEX(t,rs,cs),TRANSPOSE(UNIQUE(SORT(FILTER(i,NOT(ISERROR(i))))))) |
Dynamic array formulas. |