erober01’s Profile

Community member since December 2018



Hello all,

I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. 

I have, in one column called Terms, cells that contains lists of terms and phrases.  For example, one cell contains the following


Hi all, I have been trying to figure it out alone but I thought I'd engage the community to see if anyone can help!  I have a column in my spreadsheet that contains phrases separated by commas - for example (though with different words), in one cell it says "Phone, computer, mouse, cell phone, water


Is there any equivalent for rank formula on Excel?


I would like to create a ranking column based on value  of another column


example :

Score | Rank

20      |  2

30      |  1

2        |  5

12       | 3

5        | 4