Many thanks to all who responded.
目前分類:title (5957)
- Aug 28 Tue 2007 20:39
Help
- Aug 28 Tue 2007 20:39
usime time in a pivot table
I am trying to show an improvement in lapsed times for patient assessments
and want to pivot the data. I know its possible because I have a similar
- Aug 28 Tue 2007 20:39
.XValues syntax problem
I am writing a macro that includes assigning x-values from the third column
of Sheet 1 to the active chart:
- Aug 28 Tue 2007 20:39
Making checkboxes mutually exclusive
I have a workbook that has multiple sheets and is using checkboxes that are
checked for a list of questions that have YES, NO, and N/A as possible
- Aug 28 Tue 2007 20:39
Relative Hyperlinks to local files
I have a worksheet with cells linked to files contained in the same folder
as the spreadsheet file. When I created the hyperlinks, the full path was
- Aug 28 Tue 2007 20:39
Calculating number of instances occuring in an hour for 24 hours
I am trying to calculate number of customers who arrive every hour in a
day for theentire year.
- Aug 28 Tue 2007 20:39
if date statement or formula
I am trying to create an If statement that would populate a 1 in another cell
by reading the date in the cell next to it. For example, in cell A2 I have
- Aug 28 Tue 2007 20:39
HELP! Multiple if statements on the same line
How do I get excel to give an answer when two conditions must be met?
Basically, if L42gt;L43 and L43gt;0. If true, it goes on to a calculation. If
- Aug 28 Tue 2007 20:39
Text records in Excel
I am creating a text file within excel and I do not know how to create what
I think is needed and that is an end of line character for each line. The
- Aug 28 Tue 2007 20:39
HDI change paste options default to quot;Match Destination Formatting
- Aug 28 Tue 2007 20:39
Using which function to calculatiing 2 set of numbers of days from 3 dates
- Aug 28 Tue 2007 20:38
How to Set Worksheet Name to a cell Value in WorkSheet?
I am trying to set the name of a Sheet to a Cell within that sheet. Example
its current name is quot;Sheet1quot;. I need the sheet name to change to a value in
- Aug 28 Tue 2007 20:38
Q about: IfAnd or is it AndIf?
Dear folks,
- Aug 28 Tue 2007 20:38
calculation for bank interest chargeable
Hi to all
Required calculation for bank interest chargeable on working capital loan
- Aug 28 Tue 2007 20:38
How to restore the line of: File, Edit, View, in excel
My excel 2003 now does not show the top line with the options: File, edit,
View, Insert, Format, Tools, Chart, Windows, Help
- Aug 28 Tue 2007 20:38
Forcing english date format
- Aug 28 Tue 2007 20:38
Circular reference help!
Hi,
- Aug 28 Tue 2007 20:38
Sort Columns in Pivot Tables
I have a pivot table that has columns quot;lt;5quot;, quot;5-7quot;, quot;7-10quot;, quot;10-12quot;
and quot;gt;12quot;. However, when the pivot table comes up, they are out of
- Aug 28 Tue 2007 20:38
2 Axis Column Chart
I want to create a column chart that has one data series on the left axis,
and the other series on the right axis. Pretty easy if you want the 2nd axis
- Aug 28 Tue 2007 20:38
Return an empty or blank cell value?
When I use the IF function in most cases, I want it to either show some text
or nothing at all. I have always performed this function as in the following