So I have a ranking system, and when here is a tie, instead of listing all the people with the same score, it repeats the same name.
The example attached is a version I have made for the example. Its really reading from 2 pages (the empty column represents the separation in
Sheets so I kinda need to use the VLookup. Any solution or alternatives would be appreciated.
Thanks!
Last edited by JoeKerr99; 05-18-2021 at 02:35 PM.
Are you using 365, as 2021 is not a valid version (it's a build number)?
If so tryFormula:
Please Login or Register to view this content.
Yes, its 365.
I entered that formula into H3 and it returned #SPILL!
Any suggestions??
You need to delete the contents of the cells below & the formula should automatically spill down.
Perfection! Thank you!!
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks