Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to convert data value in a range of cells according to a specified
rule. For example, To divide the value in each cell by the value in the first cell (row) in each column and multiply by 100. 1 2 100 100 2 3 200 150 3 4 To 300 200 4 5 400 250 5 6 500 300 If I enter formula for each cell one by one, it will be a very laboring process. It seems there should be a simpler way to do this. Can someone please help me? Thank you very much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change results , change data in othe cells across the row | Excel Worksheet Functions | |||
posted data in a range of cells can't change after three days | Excel Programming | |||
change range of cells to another currency | Excel Worksheet Functions | |||
How do I change a range name back to the underlying data range? | Excel Worksheet Functions | |||
Copy cells into range of cells until cell change | Excel Worksheet Functions |