Unique Rank Formula – 1 in Google Sheet
In Google Sheets, you can use the UNIQUE and RANK functions together to generate unique rank numbers for a list of values.
Assuming your list of values is in column A, you can use the following formula to generate unique rank numbers in column B:
=ArrayFormula(IF(A2:A="",,RANK(A2:A,UNIQUE(A2:A),1)))
This formula first uses the UNIQUE function to create a list of unique values in column A, and then the RANK function to generate the rank of each value in that list. The third argument of the RANK function is set to 1, which means that the function will return unique rank numbers.
The IF and ArrayFormula functions are used to apply the formula to the entire column, while also checking for empty cells in column A. You can adjust the range A2:A to match the range of your actual data.
No comments:
Post a Comment