Forum Discussion
Solved
Help! I'm trying to pull and sort info from the same page!
Hello! I need help with Excel, I'm trying to pull info from U4:U18, X4:X18, AA4:AA18, AD4:AD18, and AG4:AG18 and put it into a chart starting on H6. I can do one with the formula =UNIQUE(SORT(FILTER...
=LET(all, VSTACK(U4:U18, X4:X18, AA4:AA18, AD4:AD18, AG4:AG18), SORT(UNIQUE(FILTER(all, all<>"", ""))))
=LET(all, VSTACK(U4:U18, X4:X18, AA4:AA18, AD4:AD18, AG4:AG18), SORT(UNIQUE(FILTER(all, all<>"", ""))))