目前分類:title (3013)
- Jul 20 Thu 2006 20:08
Exclude more than one row from data-gt;Sort
- Jul 20 Thu 2006 20:08
How to programatically control a 3D-sum?
I have done
SUM(OFFSET(INDIRECT(quot;Sheetquot;amp;numberamp;quot;!E8quot;)..etceter a) to get a sum from a
- Jul 20 Thu 2006 20:08
Delete rows in filter view
Have a spreadsheet that contains empty cells. Want to delete all empty cells
at one time (if possible). Have filtered column to show only empty cells.
- Jul 20 Thu 2006 20:08
How do I change a letter to a number in an excel spreadsheet?
I have an excel spreadsheet for employee health insurance deductions. In the
coverage colum I have coverage noted as either E, ES, EC, F or D. What I'm
- Jul 20 Thu 2006 20:08
Linking Spreadsheets from two files
I have two Police academy classes, one in the day and one in the evening.
For the staff I want to combine both spread sheets into one. When I make
- Jul 20 Thu 2006 20:08
truncating text
hello
- Jul 20 Thu 2006 20:08
print preview commands
My 'margins' print preview command disappeared. How do I get it back?
- Jul 20 Thu 2006 20:08
problem with checkbox control
Hi all
- Jul 20 Thu 2006 20:08
Run a macro if a certain value is entered in a cell
Hi,
I want to have it so that on a column if a certain value is entered in any
- Jul 20 Thu 2006 20:08
Moving Average Trendline
The graph I am creating has a lot of noise in it. I want to smooth it out.
Right now I am using a moving average trendline that kind of does the trick.
- Jul 20 Thu 2006 20:08
I copied a workbook to a CD. I can only access 1 worksheet.
I copied a workbook, from work, with multiple worksheets to a CD. When I
opened the spreadsheet at home only 1 worksheet is visible. All other
- Jul 20 Thu 2006 20:08
Help! importing data from other worksheets...
Atg the moment, i am using vlookup's and if's, sumif's etc to get info from
one spreadsheet to another and adding it up.
- Jul 20 Thu 2006 20:08
Looking for Macro to load data from Access table
I need to code a button to delete data in a spreadsheet then reload
the data from an Access table. I'm a new excel user so I down know
- Jul 20 Thu 2006 20:08
Sumif or Sumproduct
Column B contains a formula result of either quot;DUPquot;, quot;NoDUPquot; or its blank quot;quot;.
Column M contains either quot;Yquot;, quot;Nquot; or it is blank (no formula in cloumn M). I
- Jul 20 Thu 2006 20:08
accidentally click YES to overwrite an existing file
I inadvertently load my old file and saved it over my new modifed file.
Is there any way to recover my new modified file?
- Jul 20 Thu 2006 20:08
Large excel file will not open
- Jul 20 Thu 2006 20:08
How can I convert a WORD document to EXCEL?
I have received a WORD 2003 document containing hundreds of names addresses,
and phone numbers, an example of which is below:
- Jul 20 Thu 2006 20:08
Macro Formula For Summing Range
- Jul 20 Thu 2006 20:08
Graph dimensions
Hi all, Is it possible to exactly size a graph for example from A5:G30?? and
not having to visually try to come as possible to the end of a cell and so on?
- Jul 20 Thu 2006 20:08
testing possible web interface glitch -
Please don't respond to this message; it's a test. And yes, I know about
test newsgroups, but that's not what I'm testing. Really. lt;ggt; I'm testing a