目前分類:title (3013)
- Oct 22 Sun 2006 20:10
Leave existing data in a cell alone
- Oct 22 Sun 2006 20:10
sorting
I have a list of 20,000 donor records. I'd like to delete the duplicate
entries. I've sorted the list, but how would i be able to get the data so
- Oct 22 Sun 2006 20:10
How do I do running Totals in a Pivot Table
I need to have running totals in a pivot table. eg:
ComputechFNB
- Oct 22 Sun 2006 20:10
How do you protect the formula?
- Oct 22 Sun 2006 20:10
Average data/reduction
I have a number of worksheets where each contains two rows of data
representing wind speed and direction recorded every 10sec (8636 records per
- Oct 22 Sun 2006 20:10
Can Someone Help me With a Nested VLOOKUP
I have the following Data
- Oct 22 Sun 2006 20:10
Date and Time
I need to know how to add hours to a time. Example: I am trying to schedule
medicine administration to one patient with three different medicines
- Oct 22 Sun 2006 20:10
Compare date against multiple dates
I have a date (say current month) and I want to check to see if that date is
before, after or in the same month as other dates found in other cells.
- Oct 22 Sun 2006 20:10
Excel Form and Data Retrieval
I'm trying to create a rather complicated form and I'm not sure where
to begin. I am a research technician for a paper mill and often times
- Oct 22 Sun 2006 20:10
Centering comments
- Oct 22 Sun 2006 20:10
calculation formulas
- Oct 22 Sun 2006 20:10
How can I lock worksheets while macros can still enter into them?
I want to lock worksheets for outside users. But when I do it and a macro
needs to go into the worksheet, the system gives an error. So is there a way
- Oct 22 Sun 2006 20:10
Allow relative referencing for imbedded sheetnames in formulas
Please share whether it is possible to somehow imbed sheet names contained in
a cell to allow for relative referencing in a formula...so autofill can be
- Oct 22 Sun 2006 20:10
VBA to Copy Cell Value Without Formula
Hi
- Oct 22 Sun 2006 20:10
Named Reference
Hi,
- Oct 22 Sun 2006 20:10
How do I start excel without a CD
After trying to download updates for Office which failed, I found that when I
tried to open Excel it asked for the program CD, which I don't have because
- Oct 22 Sun 2006 20:10
search data set, then put in all info base on one critera
i have a data set that is two columns ten deep. abc (text) on left and 123
(Numeric) on right. how do i have a drop box (list) any where on the
- Oct 22 Sun 2006 20:10
Excel shows formula, not result
Help! I have a conditional formula that will not show the result. It shows
only the formula. Right now, the formulas box in the view tab under
- Oct 22 Sun 2006 20:10
how do i chart the data below
AAAABBACC
3/17/20064607653599
- Oct 22 Sun 2006 20:10
How do you globally display quot;Allquot; in an Autofilter?
I am working with Autofilter and I notice that when I filter one column and
then filter another column there is no way to quot;Show Allquot; throughout the