|
|
Counting fill color. by
Jeff
I'm trying to write a formula that will count a cell if it
has a certain fill color. For example, I have a range of
cells, A1:A3, where A1 & A2 are filled with...
|
|
1 |
281 |
|
|
Sum Dates by
SFrick
I have a spreadsheet with 8 years worth of data in col months. For
example row5 Col's C through CF have dates starting with the first day
of the month, like...
|
September 18th, 2003 12:26 PM
by SFrick
|
3 |
302 |
|
|
Preserve formula in cell by
Weatherall Ian D.
Hello All,
I am creating a scheduling workbook with 2 work sheets, the first sheet is
the schedule itself and the second is the availability. When a staff...
|
September 18th, 2003 12:02 PM
by Anon
|
1 |
118 |
|
|
Converting ASCII comma delimited by
Billy the brick
I have a file from the Australian Bureau of Statistics
which is in excel, but is ASCII comma delimited.
None of the usual excel functions will recognise...
|
|
1 |
347 |
|
|
|
|
1 |
326 |
|
|
If then formula by
Biff
Hi Howard,
There are several ways to do this depending on how many
variables there are. Here's one way:
=CHOOSE(A1,400,375,325)
Whatever number you enter in...
|
September 18th, 2003 11:51 AM
by CLR
|
3 |
164 |
|
|
Some problem with the Site???? by
Neeraja
Hi,
In the Community NewsGroups why i am unable to see the
updated information. The last question i can see is the
one posted on 17th Sep 2003 10.34pm.
Till...
|
September 18th, 2003 11:49 AM
by Robert
|
2 |
262 |
|
|
Extracting data from other worksheets by
Stearn
How do I extract data from another worksheet with the same
ID?
E.g. (Column A will contain the ID and column B will
contain the quantity)
Worksheet 1
A5 -...
|
September 18th, 2003 11:47 AM
by Anon
|
2 |
211 |
|
|
Multi level calculations by
Robert
Hi All :-)
I am trying to create a formula.
A1=(B1*C1) OR (D1*E1)
B2=(A2/C2) OR (D2/E2)
C3=(A3/B3) OR (E3/D3)
I wish firstly to lock cells A1,B2 & C3 as to...
|
September 18th, 2003 11:42 AM
by Anon
|
1 |
251 |
|
|
Changing date formats by
paul
I need to change the date format from 31/8/2003 to
8/31/2003. Could some one help? Under format, I tried
changing it but it goes to an incorrect date.
Paul
|
September 18th, 2003 11:17 AM
by Anon
|
1 |
296 |
|
|
Column names and deletions by
Larry
I'm converting a spreadsheet from Works to Excel. I have
two questions:
1) Is it possible to name the columns? e.g. name, date,
etc. instead of...
|
September 18th, 2003 11:07 AM
by Anon
|
1 |
262 |
|
|
Formula by
Harold
I am trying to find a formula to give a collum
of "X"s,"Ph"s,and"*"s,a value of 1 for each,
the collum is L6:L168
The total would show in cell L177
I don't...
|
September 18th, 2003 10:47 AM
by Anon
|
1 |
117 |
|
|
|
September 18th, 2003 10:47 AM
by JMay
|
2 |
316 |
|
|
|
September 18th, 2003 10:26 AM
by Anon
|
0 |
202 |
|
|
|
|
0 |
427 |
|
|
Removing Macros by
Gray
I am using a workbook (30 worksheets), created by someone
else, that contains macros (A message appears everytime I
open the book that asks for me to enable or...
|
September 18th, 2003 07:17 AM
by Dennis
|
2 |
231 |
|
|
How to Calculate average on every day! by
Alan Tang
Hello:
I have problem on how to calculate the daily average! Would you mind
to give me some hints?
Raw Data format!
"Time","Free Megabytes"
"08/01/2003...
|
|
4 |
321 |
|
|
referencing a cell pointer in AVERAGE by
Karen
Columns of numeric grades are to be averaged, but teacher
wants to choose where quarter averaging begins and ends.
I want to just have them enter...
|
September 18th, 2003 06:13 AM
by acw
|
2 |
232 |
|
|
|
|
2 |
264 |
|
|
excel data hidden by
Julie Gainey
I was working in Excel on a completed spreadsheet, hiding
some data preparing to do a mail merge. I had to close
the program due to someone else using my...
|
September 18th, 2003 05:43 AM
by Gray
|
1 |
253 |