In OpenOffice (or LibreOffice), is there a way to rank rows?
For example, let's say you have a spreadsheet where cell A1=20, A2=30, and A3=10.
I want to B1 to get a value of 2, B2 to get a value of 3, and B3 to get a value of 1. This ranks them from smallest to largest.
If the values in A1, A2, or A3 change, I want the rank to automatically update.
I would prefer not to use macros, and would like this to work for an arbitrary number of rows.