|
|
Change View SIze on all Worksheets at once by
Brent
Is there a way to change the View size (200%-25%) on all
the worksheets in your workbook at one time. I use both
Mac and PC platforms but when going from one...
|
|
1 |
524 |
|
|
Worksheet formula - auto populate by
Brent
I have a workbook containing (2) worksheets.
Worksheet 'A' contains various calendaring info. I use this to keep track
of what schools I visit on what date,...
|
April 5th, 2009 09:22 PM
by Brent
|
4 |
67 |
|
|
PMT function by
Brent
I can't ever seem to get the payment function to calculate properly. I am
entering an $80,000 loan with and interest rate of 8% payable over 5 years.
This is...
|
February 11th, 2009 07:41 AM
by joeu2004
|
2 |
68 |
|
|
|
|
4 |
124 |
|
|
|
March 16th, 2006 08:20 PM
by Domenic
|
5 |
90 |
|
|
Variable criteria formula by
Brent
Column 'A' contains 2-digit codes (i.e. LB, BA, BB, etc.).
Column 'C' contains dates (mm/dd/yy format)
Column 'L' contains mileage figures.
Attempting to...
|
February 28th, 2006 06:48 AM
by Biff
|
4 |
146 |
|
|
|
|
2 |
78 |
|
|
Lookup by
Brent
I would like to type a value on one page of my worksheet. Then have a
function in the column next to the value that looks up the value typed in and
references...
|
|
2 |
58 |
|
|
|
October 27th, 2005 12:47 AM
by Brent
|
2 |
171 |
|
|
|
|
5 |
128 |
|
|
|
|
1 |
114 |
|
|
FINANCIAL FUNCTIONS by
Brent
I have created a worksheet to compute future value for
various investments using different rates of return and
then showing the net return after taxes in...
( 1 2)
|
September 9th, 2004 12:43 AM
by Brent
|
13 |
302 |
|
|
|
|
1 |
104 |
|
|
M=1000 by
Brent Becker
I need to have Excel 97 to look at a cell with the letter
C or M in it and put the numerical value in another cell.
i.e. m=1000 c=100
Thanks
|
|
2 |
85 |
|
|
excel storing previous cell values in memory by
Brent Bortnick
When a value is entered into a cell, you can move to the cell beneath it and
start to type the same value. Excel will recognize the value being similar
and...
|
|
2 |
89 |
|
|
Format Cols by
Brent E
I've got an Excel workbook that contains many license numbers and I need to
format the column so that if a license number has several 0s in front, they
aren't...
|
April 29th, 2005 02:46 AM
by Max
|
2 |
72 |
|
|
If Statement Criteria by
Brent E
Good afternoon,
I am trying to assist somebody at work. I would like to ask if there is a
way to set a formula in a totals cell at the bottom or a...
|
|
2 |
78 |
|
|
searching a workbook by
Brent Zirbel
Is there a way to search an entire workbook for data
instead of going into each page and doing a search? It
gets kind of old going into each page and doing a...
|
|
2 |
87 |
|
|
create "IF" formula ? by
Brent05Redfire
I am trying to figure out how to add two cells on the same row if a cell to
the right is true.
I have a list of projects listed numerically by job number and...
|
September 23rd, 2009 04:40 PM
by T. Valko
|
3 |
99 |
|
|
Rolling figure to a cell by
Brenton
I am trying to calculate a rolling figure to a cell by updating a spread
sheet on a weekly basis. I want to input data on a dated row and get the
formula to...
|
September 19th, 2008 05:36 AM
by Brenton
|
2 |
135 |