|
|
IF Formula take 3 by
Matt
Sorry for not explaining the problem better.
With the formula =INT((TODAY()-D10)/365.25);
I get a value of "0" for the first year past todays date, and I can...
|
|
2 |
47 |
|
|
cell formatting by
Tom
is there a way to take an area of about 10 rows and change the cell height to
0.1 so that there are now 100 rows in the original area?
|
|
5 |
43 |
|
|
|
|
3 |
65 |
|
|
Formatting? may be by
ab3d4u
I do a lot of subtotaling. I have different depts with diffeent charge codes but all share the same GL code. Ex Printing/Copy GL code 4400, for admin it will...
|
November 8th, 2007 06:40 PM
by RyGuy
|
1 |
84 |
|
|
Page numbers on various worksheets by
Matt @ L Bar Nevada
I am using Excel 2007 and have various worksheets that I will print out one
after another. Basically I want to put custom page numbers(different from the...
|
|
0 |
79 |
|
|
Hyperlink to range of cells by
DaveFinn
I have this worksheet that has lots of graphs etc. I would like to make the
reading experience better for users so that they wouldn't have to scroll down
all...
|
November 8th, 2007 06:29 PM
by Beege
|
8 |
76 |
|
|
|
|
1 |
56 |
|
|
Separating information in cell by
Cynthia
I am using Excel 2003 SP2. I receive reports with first and last names
together in one cell:
Jones,Edward
Smith, David
Longview,Samantha
Is there a way to...
|
|
5 |
57 |
|
|
|
|
5 |
67 |
|
|
IF formula with 3 possible outcomes by
Aaron Hodson \(Coversure\)
Hello everyone,
I am trying to get the following formula to work, without success.
I would like C3 to have 3 possible outcomes, 1,2 or 3. This data will be...
|
|
8 |
118 |
|
|
Indirect - Multiple Sheets/Cells by
Keep It Simple Stupid
I have several sheets that I need to pull the information from cells K20,
K65, and K79 for each sheet.
On a "Summary" sheet, I have listed the sheet names in...
|
|
5 |
67 |
|
|
|
|
3 |
119 |
|
|
IF Formula by
Matt
Take 2..
I am trying to get a formula that will assign a numeric value for a each
year past "TODAY". The TODAY date needs to change every day.
Today to...
|
|
2 |
58 |
|
|
remove colored rows by
climate
Hi
I have 2 columns that many of it's rows has colored ( colored cells in
first and second column is equal) , i want to remove colored rows.
Would you please...
|
|
6 |
66 |
|
|
Formaulating in Execel by
Matt
Can some one help me with the following formula?
I need to create a IF formula that will start with the current date "=TODAY"
and count backwards appling a...
|
|
4 |
70 |
|
|
IF Formula by
Matt
Can anyone help me with the following formula?
|
November 8th, 2007 03:57 PM
by Matt
|
0 |
53 |
|
|
Excel Macros 2003 into 2007 by
Lyndsey Wood
I have created a button (using the VB toolbox) in a 2003 version of excel. I
then saved the workbook and opened it up in excel 2007. When I click on the...
|
|
1 |
69 |
|
|
Price Function by
snowsnow
Hey Guys:
Can anyone tell me how Excel pricing ACT/365 using Price formula?
Because If I do it manually, I don't get the same answer. I have looked at
the...
|
|
4 |
60 |
|
|
|
|
3 |
70 |
|
|
INDEX FORMULAS & MULTIPLE TABLES by
Aaron Hodson \(Coversure\)
Hello everyone,
I am using the below formula to capture data from a table in my spreadsheet:
=INDEX(F3:H22,MATCH(B9,E3:E22,0),MATCH(B3,F2:H2,0))
Within the...
|
|
9 |
89 |