Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
two columns percent in third
How do I do a 3rd column of percent of two other columns without entering
=j1/k1, =j2/k2, etc? I can do the total percent in a box at the end, but I would like each row percent. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
two columns percent in third
Enter
=J1/K1 in L1 and then with L1 highlighted, grab the 'fill handle' (small square in bottom right of cell), left click on it, hold the mouse down and drag as far as you want, Excel will look after the incrementing of the row numbers in the formula -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk "Common Rock" <Common wrote in message ... How do I do a 3rd column of percent of two other columns without entering =j1/k1, =j2/k2, etc? I can do the total percent in a box at the end, but I would like each row percent. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |