Hello,
I was wondering if anyone could help with me with a formula.
What I am trying to achieve is to list all the names that has a number beside it from highest to lowest.
My data: first column(A) has a list of names, second column (B) has a list of numbers. (some names may not have a number beside it)
Tim 5
Bob
Adrian 1
Helen
Kieran 2
Chloe
Maggie 3
Glenn
Rick 1
George
Output: Columns C and D is where the output would be.
Tim 5
Maggie 3
Kieran 2
Adrian 1
Rick 1
Appreciate any help given
Thanks
Bookmarks