Hi,
目前分類:title (4957)
- Apr 13 Sun 2008 20:43
Counting Dates
- Apr 13 Sun 2008 20:43
language support in excel sheet using a third party language tool
I am using a 3rd party language tool for displaying hindi and kannada scripts
on excel sheet. there are few fonts meant specifically for using this
- Apr 13 Sun 2008 20:43
I have a math problem in Excel.
I have a math problem in excel. That I have found. Now that I have found it.
I have no way to send it to Microsoft unless I pay them. Any idea how I can
- Apr 13 Sun 2008 20:43
format a cell to read zero for any negative value
I would like some advise to show a zero value in a cell when ever the sum
value of this cell is a negative value
- Apr 13 Sun 2008 20:43
Average every 20 rows
I have a data of 14000 rows. I need Average on every 20 cells. Instead of
copying and pasting the formula into every 20 cells to get the result which
- Apr 13 Sun 2008 20:43
Loop for VBA code?
quot;I would like to use the VBA codes bellow that were writen by Gerry
Shaw in order to calculate some properties of proteins and DNA. However
- Apr 13 Sun 2008 20:43
indirect.ext question
I am having one minor issue with the indirect.ext function. Everything works
great when I type in this:
- Apr 13 Sun 2008 20:43
Have Excel format xxxxxx into date format
I've looked all over the place and can't find this anywhere. We just want to
type numbers such as 020406 and have Excel format as 02/04/06. Can anyone
- Apr 13 Sun 2008 20:43
Password Protections Not Working
I have a user that opens an Excel file in Read/Only every time she
tries to open it. Everyone else needs to put in a password to open it and
- Apr 13 Sun 2008 20:43
Missing values from SAS
I am forced to work with an Excel sheet that was imported from SAS. It
contains the standard period quot;.quot; in all cells where the data was missing. I
- Apr 13 Sun 2008 20:43
Printing Odd or Even Pages
Hi,
- Apr 13 Sun 2008 20:43
Retrieving Worksheet Name
I am trying to find a function that will retrieve a worksheet name if the MAX
function retrieves a number from that work sheet. Any Ideas?
- Apr 13 Sun 2008 20:43
Multiplying
I wan to Multiply a number in a cell I call A1 by .00029 and its answer in A4
.. Then be able to add up the entire A column in A6.
- Apr 13 Sun 2008 20:43
3D Referencing and/or a query
Hi, I am in trouble and I can't figure out how to do this! I am in Property
Management amp; I have a workbook that is 25 pages of information on residents.
- Apr 13 Sun 2008 20:43
Excel 2000 Invoice Template Macro Password?
Can someone tell me the password to view the macro code in the Invoice template that
comes with Excel 2000?
- Apr 13 Sun 2008 20:43
Formula
I have column A with Prices; column B contains formula - Price x 0.05; column
C contains formula - sum of Col A and Col B. When I drag these formulas down
- Apr 13 Sun 2008 20:43
I would like to merge two rows
hi - I want to merge two rows and make them one row
Select the cells
- Apr 13 Sun 2008 20:43
Getting wrong value due to ref?
- Apr 13 Sun 2008 20:43
Sumif Cells Are Not Blank
I'm looking to total a range of cells ONLY if they have a value of 0 or more
entered in them. In plain english:
- Apr 13 Sun 2008 20:43
How do I sum data in worksheet 1 to be placed in worksheet 2?
Worksheet 1 has data that I need summed up for placement into worksheet 2.
How do I accomplish this?Thanks