| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how do i find percentage from 2 different pages in Excel?
i AM WORKING WITH 2 SETS OF ANNUAL FIGURES AND i WOULD LIKE TO COMPARE THE
TWO BY PERCENTAGE. THE FIGURES ARE ALL IN THE SAME DOCUMENT BUT ON TWO DIFFERENT SHEETS. HOW WOULD I SET UP A SHEET THAT WOULD ALLOW ME TO DO THIS? |
|
#2
|
|||
|
|||
|
Hi fp
If your data is in Sheet 1 cell A1 and Sheet 2 B1 for example. Setup a new sheet and put in the formula: =Sheet1!A1/Sheet2!B1 HTH Michael "fpbuckland" wrote: i AM WORKING WITH 2 SETS OF ANNUAL FIGURES AND i WOULD LIKE TO COMPARE THE TWO BY PERCENTAGE. THE FIGURES ARE ALL IN THE SAME DOCUMENT BUT ON TWO DIFFERENT SHEETS. HOW WOULD I SET UP A SHEET THAT WOULD ALLOW ME TO DO THIS? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
| Excel program not printing all pages... | New Users to Excel | |||
| macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
| How do I remove pages in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
