SQLite Forum

Get column rank from values in selected row
Login
That would be "spreadsheet thinking". Doable but arduous. Try some "database thinking" instead. There are good reasons for normalizing tables in databases. They just work so much better when used as designed.