I just created a simple worksheet to total volunteer hours that help with
band boosters. It then occurred to me that I could build a workbook that
目前分類:title (5957)
- Aug 28 Tue 2007 20:38
Creating a summary page in Excel
- Aug 28 Tue 2007 20:38
Links
- Aug 28 Tue 2007 20:38
how do I stop excel putting a space after a decimal point
Excel automatically places a space after a full stop/decimal point. this
results in it not recognising numbers as numbers... any help gratefully
- Aug 28 Tue 2007 20:38
How do a put two pies (series) in one chart
I've been trying to put 2 pies of comparable data (1 for men and 1 for women)
on a single chart but despite trying to use the secondary access, I can't
- Aug 28 Tue 2007 20:38
count col-A if col-B = condition
i have some data that is organized terribly, and it's HUGE.
- Aug 28 Tue 2007 20:38
Creating a formula in excel
I need to create a report in excel and then total by areas at the end of the
report. I cannot figure it out.
- Aug 28 Tue 2007 20:38
how do I consolidate multiple pivot tables into one pivot table?
I have 6 pivot tables on 6 different tabs in Excel and I want to combine them
so I can have one main pivot table. Does anyone know how to do that?
- Aug 28 Tue 2007 20:38
data validation
i am having a problem where validation seems to disappear after i add data to
a list. i created a list of data and defined a name. i included extra rows
- Aug 28 Tue 2007 20:38
Macro that looks at cell contents
- Aug 28 Tue 2007 20:38
Restore won't work any more
I can no longer re-size Excel. When I click the restore icon, the workbook
just minimizes. I then have to right click the file on the task bar and
- Aug 28 Tue 2007 20:38
How do I extract the month end value from a daily time series?
Hi. I have a financial time series (a two column array consisting of the
columns 'date' and 'price') containing weekday values of a stock price.
- Aug 28 Tue 2007 20:38
Template becomes Unprotected
I have created an Expense Template for associates to use. All formulas are
protected and some cells are unlocked so they can make entires. Every once
- Aug 28 Tue 2007 20:38
duplicate workbooks
I am not sure how this happened, but everytime I open a particular workbook,
it simultaneously opens another one. The workbook file that I want to open
- Aug 28 Tue 2007 20:38
Pivot Table Formatting
I would like to customize the formatting of the pivot table I have created.
Add colors, grid lines, etc. However, each time the data is refreshed, the
- Aug 28 Tue 2007 20:38
How to determine following function in Excel?
I would like to set following conditions in Excel, but find it difficult on
coding.
- Aug 28 Tue 2007 20:38
adding average to pivot table
- Aug 28 Tue 2007 20:38
To Rank on two Criteria
How can i use the RANK function or any other functions on criteria from two
columns. One column in descending order, the other in ascending order.
- Aug 28 Tue 2007 20:38
Pivot Table
Hello All,
- Aug 28 Tue 2007 20:38
to large if formula
hi trying to wright a if formula eg if b1=1 then (c2*d2 e2) if b1=2 then
(c2*d2)
- Aug 28 Tue 2007 20:38
Converter from MS Works 4.5 spreadsheet to MS Excel 2003
I'm very disappointed that one MS spreadsheet cannot read another MS
spreadsheet: in this case MS Works 4.5 and MS Excel 2003. I have been thru