I am looking for a formula to allow me split a spreadsheet's rows into quintiles i.e say I have 100 rows, then each quintile is 20 rows. I then want to allocate a score of 5 to each row in the first quintile, 4 to each row in the second etc. etc.
Any ideas as to how to achieve this would be very welcome indeed !.
Thanks