Please anyone help me for creating a Rank List from Airtable or Google Sheet

Discuss
#1

I need Rank List from Descending Order, Like Rank | ID | Mark in this format, Pls anyone help me. Am creating an app for Exams. Here I Attach my Blocks

blocks(1)
blocks(1)2674×1380 140 KB

#2

Did you try listUtils extension…?

Try to use bubble sort the list

#3

Am Using List Addon Extention. It sorts only the Marks, But Name will not ascending

#4

Refer here

1 Like
#5

Why not use google sheets rank formulas to do the work, then bring the results down to your app ?

#6

Select Data Form Spreadsheet (Like Vlookup data form Spreadsheet) - #3 by TimAi2?

You can use query and use sort of your data

#7

I didn’t understand whether you want to get all the column information with an identifier in column A

#8

So Finally, I used Sort Query and Retrive it. Thanks to Everyone…!