So since you ranked them, you can use that column...
In H2: =IF(C2<=5,A2,".")
and in I2: =IF(C2>=LARGE($C$2:$C$25,5),A2,".")
copied down.
So since you ranked them, you can use that column...
In H2: =IF(C2<=5,A2,".")
and in I2: =IF(C2>=LARGE($C$2:$C$25,5),A2,".")
copied down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks