how do i find percentage from 2 different pages in Excel?

F

fpbuckland

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?
 
M

Michael

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Section and Page numbering 0
Word VBA - Want to test if Full Name is NOT Present in document 0
VBA word change keys 0
Percentage Increase 11
Slideshow with black border around it 1
Inconsistent formatting of section numbers 0

Top