|
|
Easy function question by
Dahlman
I have 3 columns. the first column is a Scheduled Date and the 2nd column is
an actual ship date. I want my 3rd column to gime a "Yes" if it is on time
and a...
|
March 31st, 2005 12:35 AM
by Dahlman
|
2 |
234 |
|
|
Excel Custom Format by
MistyR
I want to format a cell in Excel to always have the word "Tuition-" then
whatever I type in. I could get it to work if I type in numbers, but not
alpha. I...
|
March 31st, 2005 12:47 AM
by Jane
|
1 |
97 |
|
|
max rows on an Excel worksheet by
vbjenny
I thought the maximum number of rows available on an Excel
spreadsheet was 65,536. But recently I was told the
number of rows could be increased by decreasing...
|
|
2 |
182 |
|
|
Copy cell formula help by
tamato43
I've created a spreadsheet with a dozen colums and about 150 rows.
in the 1st row cells I have a conditional formula which states Sumif "cell
Range", "Salesman...
|
March 31st, 2005 12:55 AM
by Dahlman
|
2 |
60 |
|
|
Forumla calculation by
Shelly
I know this has to be an easy one, but I can't figure it out - Please help:
Formula: If the month in cell A6 matches the month in cell C2 then return
value...
|
March 31st, 2005 12:57 AM
by Jane
|
2 |
95 |
|
|
|
|
2 |
81 |
|
|
|
|
2 |
202 |
|
|
Dates by
James
I have two cells with a data in each cell. Is there a
formula that I could put in a third cell that determines
the number of days between the two...
|
March 31st, 2005 01:17 AM
by James
|
3 |
85 |
|
|
Different Headers on pages by
Larry G.
I need to create a header for the first page and then a different header for
each subsequent page. Anyone that can help with this would be great.
|
|
1 |
137 |
|
|
Match + Index(?) Question by
KemS
I have a worksheet as follows:
March 30, 2005 Mar
Jan 1
Feb 2
Mar 3
Apr 4
May 5
Jun 6
Jul 7
Aug 8
|
March 31st, 2005 01:23 AM
by KemS
|
2 |
95 |
|
|
Countif Text equals the same by
tamato43
I'd like to build a formula that states Countif the Text on cell equals the
same text on cell B.
I'm sure its an easy one.
|
|
1 |
80 |
|
|
Pie Chart by
Dahlman
I have a column titled "On time" the entries underneath this title are
either"Yes", "NO", or "NOT COMPLETED". I want to create a pie chart with the
percentages...
|
March 31st, 2005 01:59 AM
by Dahlman
|
5 |
141 |
|
|
Naming an Array by
Iain
Hi,
I have built an interactive menu system in Excel that is based around moving
a series of Text boxes and objects in front/behind an opaque square...
|
March 31st, 2005 02:19 AM
by Iain
|
0 |
76 |
|
|
|
|
1 |
95 |
|
|
|
|
3 |
177 |
|
|
Today or Now functio by
Patrick Foley
I have a cell that calculates the entry date of the row
eg =IF(A1630,$A$1,"No Data") In A1 I have =today()
This formula works fine but as I add a new row to...
|
|
3 |
133 |
|
|
Rotate a Excel table by
Need Helper
I know that we can rotate text within a cell.
Is it possible to rotate a table within the Excel spreadsheet from the
landscape orientation to the portrait...
|
|
1 |
78 |
|
|
$ Formats by
James
Hello again,
I'm trying to change the format of a cell so that it
reads as "AUD$" rather than just "$".
I have tried the custom formats, but can't get it to...
|
March 31st, 2005 03:18 AM
by James
|
2 |
86 |
|
|
|
March 31st, 2005 03:35 AM
by CLR
|
2 |
182 |
|
|
|
|
2 |
97 |