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) |