Forum Discussion

ledesma92's avatar
ledesma92
Copper Contributor
Feb 03, 2025

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(U4:U18,U4:U18<>""),1))

so I tried to see if I could add the other ones to this one formula, because I have 5 days (Mon-Fri) I need to reference, but it doesn't work out for me. I tried 

=UNIQUE(SORT(FILTER(U4:U18,U4:U18<>""),1)(sort(filter(X4:X18,X4:X18<>""),1)) etc.

=unique(sort(filter((U4:U18,U4:U18<>"")(X4:X18,X4:X18<>"")(AA4:AA18<>"")(AD4:AD18<>"")),1))

I don't know what to do. I'm not super familiar with Excel, I've only taken classes, basically back in middle school (I'm 32) so I don't remember much, I'm trying to pull the formulas from my old managers original report to make my own report, but this is where I am. any help would be great!

  • =LET(all, VSTACK(U4:U18, X4:X18, AA4:AA18, AD4:AD18, AG4:AG18), SORT(UNIQUE(FILTER(all, all<>"", ""))))

  • ledesma92's avatar
    ledesma92
    Copper Contributor

    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.

  • =LET(all, VSTACK(U4:U18, X4:X18, AA4:AA18, AD4:AD18, AG4:AG18), SORT(UNIQUE(FILTER(all, all<>"", ""))))

Resources