Automatically highlight certain data.
Wed, 28 Apr 2010 14:02:43 -0400
I have a spreadsheet with a schedule of duties that are done every Sunday.
Different people are assigned each week for each duty.
For instance:
Sunday, May 2
Greeters Mr. x
Ushers Mrs. y
Counters Ms. z
It's a vey long list and a very large spreadsheet (covers several year ...
|
Simplify formula
Wed, 28 Apr 2010 10:30:15 -0700 (PDT)
Evening everyone, I was urgently trying to get create a formula that
did what I wanted it to do and by trial and error managed to get it.
Only problem is that I think it's far too cumbersome for its own good
and will ultimately slow the performance of my workbook down.
The formula is as follows:
=IF(AND(SUMI ...
|
Formula to Identify groups of numbers to be added.
Wed, 28 Apr 2010 10:25:41 -0700 (PDT)
Hoping I can get a cell formula that will calculate as follows:
Cells in Column H have this relative formula in them.
=IF(M12="Yes", "",C12)
This results in a cell will either show a number, or is blank.
Each week or so, another entry is made to the next empty line.
After awhile, Column H might look somethi ...
|
How to Wrap Text
Wed, 28 Apr 2010 09:57:01 -0700
I have a 267 characters texts field. MS Excel 2007 will not show all the
texts. It showed a bunch of ## symbols in the cell. I have tried several
tutorials on how to wrap texts but it didn't work.
I have tried these:
http://www.dummies.com/how-to/content/how-to-wrap-excel-2007-data-to-see-all-the-text.html
...
|
Strange cell behaviour
Wed, 28 Apr 2010 09:58:09 -0500
We are trying to type a number range in a cell in an excel 2002 spread
sheet, ex. '10-20' (without the quotes).
When we leave the cell, it defaults to date format, '20-Oct'.
When we change the format of the cell to number or general, it fills in
with '40471'.
What can we do to get the cell to display li ...
|
Using AVERAGEIFS to calculate average rating for programs-Reposted (was
unclear)
Wed, 28 Apr 2010 06:56:45 -0700
Here is an example for the Rating database:
Date Start Time End Time Channel 1 Channel 2 Channel 3 Channel 4 Channel 5 Channel 6 Channel 7 Channel 8 Channel 9 Channel 10
1/2/2010 06:00 06:15 0 0 0 0 0 0 0 0 0 0
1/2/2010 06:15 06:30 0 0 0 0 0 0 0 0 0 0
1/2/2010 06:30 06:45 0.1 0.1 0.1 0.1 0.1 0 0.1 0.2 0. ...
|
Conditional Formatting across different worksheets
Wed, 28 Apr 2010 06:31:04 -0700 (PDT)
Hi everyone,
I am reposting my message, as the previous one was not clear. I think
that I have to go to VBA, as it was suggested. Does anyone have the
code? The problem is as below:
I have two sheets, one that I use as a control (i.e. a back up) that
I
will call Sheet 2, while Sheet 1 is a duplicate of S ...
|
|
|
Date Format
Wed, 28 Apr 2010 12:55:23 +0100
Using Excel 2002
Have written some simple code using the
Sub Auto_Open()
Trap_Entry_Log
End Sub
Sub Trap_Entry_Log()
ActiveWorkbook.Worksheets("Log").OnEntry = "Validate"
End Sub
Then use the code 'If .Column = #' , to control entry into each column
One column contains a Custom date format ...
|
Copy range
Wed, 28 Apr 2010 13:34:18 +0200
Hello everybody, I have a problem:
In my Sheet1 I have column A, D, G, J, M, P, S and V with values I need to
copy to Sheet2. The values are only the ones that in the second column to
the right have an * (so for A - C and so on).
There is a format I must follow (val=value): CellA headervalOZ/valOZ.T and
so o ...
|
Averageifs- an example of the problem
Wed, 28 Apr 2010 03:59:35 -0700
OK, I'll try to be more specific.
Here is an example for the database:
Date Start Time End Time Channel 1 Channel 2 Channel 3 Channel 4 Channel 5 Channel 6 Channel 7 Channel 8 Channel 9 Channel 10
1/2/2010 06:00 06:15 0 0 0 0 0 0 0 0 0 0
1/2/2010 06:15 06:30 0 0 0 0 0 0 0 0 0 0
1/2/2010 06:30 06:45 0.1 0.1 0.1 ...
|
