|
|
tab by
Mmaratea
I would like to know if the tabs for the different sheets
can be in color and if that is possible, how is it done?
Thanks.
|
|
1 |
113 |
|
|
PV of Irregular Cash Flow Stream by
Ken
Hi,
Does anyone know how to discount an irregular stream of
cash flows?
Example,
Over the next five years I expect to receive payments
which will be irregular...
|
September 30th, 2003 09:10 PM
by Bill
|
2 |
304 |
|
|
concatenate/if function by
debbie
How do I make an IF statement to leave out the
dashes if the value is 0.
Example: =CONCATENATE(IF(D12=0,"",D12),+"-"
(a dash if there is a value... no dash if...
|
|
4 |
87 |
|
|
Grades Calculation by
Lyndie
Hi! I am an elementary school teacher trying to calculate
grades in an Excel worksheet. Following is a sample of
my efforts:
Points...
|
September 30th, 2003 09:27 PM
by Lyndie
|
4 |
88 |
|
|
automatic duplicate entry by
Kevin
Is there a formula that can be entered into a cell that
automatically pulls whatever is typed into a different
cell? Example: I want to enter a name into...
|
|
2 |
253 |
|
|
On opening a spreadsheet. by
Pinda
On opening a excel workbook, is it possible to have a
default way of opening? For example, I want to display a
certain worksheet everytime on opening that...
|
September 30th, 2003 09:36 PM
by LD
|
7 |
1,363 |
|
|
Comparing two lists by
Jennifer Brooke
I have 2 lists of names and I need to compare to see which
names from List #1 appear in List #2. Could someone tell
me how to do this?
With Much...
|
|
1 |
223 |
|
|
DATEDIF by
jo
Can you help me find it?
Thank you
.
|
|
2 |
156 |
|
|
Dynamic SUMIF by
Craig C.
Will a SUMIF worksheet function work when the sum_range is
dynamic depending on user selection? The user can choose
period 1 thru 12 or YTD. If not, what...
|
|
5 |
104 |
|
|
Workbook protection by
Rita
Hi,
I have a problem with an excel file. It workbook
protected and the person who did it is not here anymore.
Is there a way I can find the password? Thanks...
|
September 30th, 2003 10:38 PM
by Rita
|
4 |
95 |
|
|
Macros - Filters by
Pinda
I've have a tables of targets with the director
responsible for them against each target (1 director per
target), with an autofilter for the table.
On a...
|
September 30th, 2003 11:35 PM
by LD
|
4 |
124 |
|
|
Finding linked cells - Error Prompt by
Steve Mc
Is there an easy way to find what cells have formulas that
refer to another worksheet.
I'm trying to Edit-Links-Change Source to the current
worksheet, but am...
|
September 30th, 2003 11:44 PM
by Steve Mc
|
2 |
382 |
|
|
|
October 1st, 2003 12:13 AM
by CLR
|
0 |
192 |
|
|
Excel File Versions by
Linda B.
Help! I have a large Excel file that has 4 versions open
at the same time. I only want one version. Please advise
how to get rid of the other three.
|
|
2 |
186 |
|
|
Date function by
Denise Ch'ng
I have two sheets in an excel workbook, one named 'Main
Audits' and the second named report spreadsheet.
What I want to do is to put the month number into...
|
|
1 |
101 |
|
|
|
October 1st, 2003 02:17 AM
by Kelly
|
5 |
584 |
|
|
|
October 1st, 2003 02:18 AM
by cindee
|
2 |
357 |
|
|
Time Sheet by
G Port
I need to set up a worksheet that will calculate the hours
work for each day. I enter start, lunch, and end and excel
gives total. EX:
Start Lunch End ...
|
October 1st, 2003 03:11 AM
by Biff
|
4 |
108 |
|
|
Can't freeze cell row by
George King
I'm not sure what you mean by 'highlight rows', then
freeze. Highlighting a row doesn't have anything to do
with selecting a row to freeze.
Two ways to do...
|
|
0 |
494 |
|
|
wedding list help by
John
I am trying to use excel to create what I need for my
weddding invitation list. My fiance wants a count of how
many people from her side of the family are...
|
|
4 |
133 |