Conditional Ranking? RANKEQ based off Category

Maram Mohamed

Hello Fellow Smartsheet Users,

I am having trouble putting together RANKEQ formula that ranks rows in my sheet by Total Aggregate Value, but only based off the Department. I would like to return top 5 aggregate values per each Department listed. Can anyone please assist?

Paul Newcome

Try using a COLLECT function in the range portion of the RANKQ function.

=RANKQ(number, COLLECT(Total:Total, Department:Department, @cell = Department@row), optional_order)