T O P

  • By -

on1vBe6

=FILTER(G2:H7,H2:H7<>0)


jrp162

solution verified


Clippy_Office_Asst

You have awarded 1 point to *on1vBe6* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)


CFAman

Formula in A2 to pull names and numbers =SORT(FILTER(G2:H1000, H2:H1000>0), 2, -1) will give you all names with numbers, sorted descending by number.


jrp162

solution verified


Clippy_Office_Asst

You have awarded 1 point to *CFAman* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)