CODEWITHSUNDEEP
google-sheets
maugch
maugch

Reputation: 1318

Sort and show two cells in one for each result + formatting

I'm trying to make a Top 10 list of people depending on their daily results. I have a column for people with each row representing a result for that day. On another sheet I want to make a Top 10 list of people plus their result. To make it easy to read, I was thinking to put Person + result in the same cell (eg. Paul - 3.5%).

I have the formula to make the Top 10 and put the result with it, but somehow I can't format it correctly to percentage. Here is the basic one:

=transpose(query(sort(CONCAT(transpose('perc weekly'!$B$3:$JNK$3),to_percent(transpose('perc weekly'!$B$5:$JNK$5))),transpose('perc weekly'!$B5:$JNK5),FALSE),"limit 10"))

I should also add a space between the two values, but that should be easy I think.

Upvotes: 0

Views: 57

Answers (1)

pnuts
pnuts

Reputation: 59485

This might help: 

=transpose(query(sort(CONCAT(transpose('perc weekly'!$B$3:$JNK$3)&" ",to_percent(transpose('perc weekly'!$B$5:$JNK$5)&"%")),transpose('perc weekly'!$B5:$JNK5),FALSE),"limit 10"))

Upvotes: 2

Related Questions