hi. i have a list of pupil data in column A. The total number of
pupils in the class is 30 and i wish to convert the data into a
percentage but i have to do this individually for each cell. for
example (in column B)
=15/30
=10/30
=5/30 etc etc.

is there an easier way to do this? thanks all.