|
|
Restated question for formula by
Vercingetorix.XIII[_2_]
The payments are split into 2- 1 month apart- I need a formula which will add
the payments to be made on Nov 1 into a cell for Nov1st - then add the
payments...
|
|
1 |
91 |
|
|
Solver or not Solver by
Marilyn
Hello
I use "solver " to calculate a formula. I need to send the woorkshet to
different people and they will have to use solver. Here are some of the...
|
|
4 |
136 |
|
|
Automatically changing arrows by
Nelson B.
I have a report for executives where I have a big "up" arrow if there was an
increase and a big "down" arrow if the amount decreased. Currently I have to...
|
|
6 |
88 |
|
|
|
|
2 |
147 |
|
|
excel by
Excel
Is there a software that I can use to convert the .spl format into Excel
format ?
Thanks
Cathy
|
|
1 |
88 |
|
|
CountIF Function Help!! by
Tina STL
I am using the countif to tell me how many times text appears in column. The
problem I have is the return seems to be counting down, I need the return to...
|
December 11th, 2008 09:16 PM
by Tina STL
|
4 |
111 |
|
|
Iserror help by
Jim
Hello,
I have the basic is error formula (=IF(ISERROR(AC21),"",AC21))
What I need help with is in cases where the formula is referencing a cell
that has 0 or...
|
December 11th, 2008 09:11 PM
by FinRazel
|
3 |
105 |
|
|
|
|
3 |
99 |
|
|
Unique Pivot Table Count by
Andy
I have a few thousand records. Two of my fields are a unique ID (unique to
each row) and customer ID (unique to each customer).
Within one pivot table...
|
|
1 |
158 |
|
|
Countdown Timer by
Robert_NSBG
I created a spreadsheet to score my daughter's basketball games. I need to
create a"Game Clock" macro that I can set the amount of time at the start of
each...
|
December 11th, 2008 08:54 PM
by Mike H
|
1 |
121 |
|
|
Widen merged columns while selected. by
Shawnn
I would like to find out how to change the width of a merged cell or column
while it is selected and then return it back when another cell is selected.
This...
|
December 11th, 2008 08:51 PM
by Shawnn
|
0 |
87 |
|
|
|
|
5 |
128 |
|
|
Excel 2007 adding page breaks by
David L[_3_]
Excel 2007 is putting page breaks on my spreadsheets and I cannot get rid of
them. Every cell has a page break above and below. Cannot adjust page
scale,...
|
|
0 |
95 |
|
|
|
December 11th, 2008 08:42 PM
by MichaelZ
|
7 |
138 |
|
|
referencing current tab name in formula by
excelhurtsme
I am trying to reference the current tab name in a formula. I am trying to
get a running total across several different sheets, but here is the catch,
those...
|
|
4 |
124 |
|
|
Displaying Links when opening sheets by
Jase
I have to regularly open several workboks at once with most of them linked to
many other worksheets. I want to be able to display the links of the workbook...
|
December 11th, 2008 08:33 PM
by Jase
|
2 |
105 |
|
|
Convert to Excel format by
Excel
Hi !
Do you any kind of software that I can use to convert .spl format into Excel
format ?
Thanks
Cathy
|
December 11th, 2008 08:09 PM
by Bob I
|
1 |
90 |
|
|
Last Line of Data by
cware
I am using a Pivot Table. On the outside of the table, I have several
calculations going on. Two of which involve finding the last line of the
data and...
|
|
1 |
91 |
|
|
leading zeros in text format by
BigBrook
I receive bulk orders via an Excel spreadsheet, containing many individual
orders with reference numbers.
The reference numbers may be 7-9 digits long,...
|
|
5 |
415 |
|
|
0 (zero) auto delete by
Ben in CA[_2_]
Hi,
Is there any way that I can set a cell to automatically empty (delete the 0)
if someone enters a zero in the cell?
(Preferably with a macro)
(It's not...
|
|
4 |
141 |