Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Quickly Review Data | Excel Worksheet Functions | |||
Copying data from one spreadsheet to another quickly | Excel Discussion (Misc queries) | |||
quickly select data to produce charts | Charts and Charting in Excel | |||
How do I quickly reverse the order of a set of data | Excel Discussion (Misc queries) | |||
sorting data different ways quickly | Excel Worksheet Functions |