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<>"", ""))))
you're amazing! that worked perfectly! thank you so much!!
think you can also help me pull the numbers and sort em too?
I'm to pull and sort the numbers from the weekly counts, to their corresponding strain. For example, the 4-Champaya has 667 on Monday, and 47 on Tuesday. I need it to add the numbers and put it with the strain on the Strain Presentation and Pieces chart.