ContributionsMost RecentMost LikesSolutionsRe: Is there a way to rank values in quickbase similar to Excel's RANK function?Hi Elwyn, Thanks for posting your solution. I have tried to use the code you provided above and I am getting the following error: There are one or more problems with your entry These function names are unknown. I've tried adding them using the "choose fields & functions", but still get an error. Any ideas what I need to check to get it working? var bool descOrder = true; // true if ranking from high to low, otherwise false var number maxrank = 0; // 0 to rank every number, else 10 to rank 1 through 10, 100 to rank 1 through 100, etc var number fieldId = 44; // the field id of the numeric field being ranked - CHANGE AS NEEDED var number rankThis = [Total kWh/sqm]; // the numeric field being ranked - CHANGE AS NEEDED var number rank = If($descOrder, Size(GetCellValues(GetRecords("{"&$fieldId&".GT."&$rankThis&"}"),$fieldId))+1, Size(GetCellValues(GetRecords("{"&$fieldId&".LT."&$rankThis&"}"),$fieldId))+1); If($maxrank=0,$rank, If($rank<=$maxrank,$rank,null)) ------------------------------ Michael Cronin ------------------------------