in [Excel]

How do I delete a calendar function from a spreadsheet I inserted a "calendar function" in one of my spreadsheets and want to resize it, but can;t figure out first how to delete it. Can anyone help? ... 27 Apr 2010 19:06
FDIST Function What is the formula used by Excel to calculate the FDIST function? ... 27 Apr 2010 17:57
How to use autofilter in excel with formula reference changing Hi, I have a table A B C 1 forro 120 2 ment 80 40 3 forro 50 30 4 ment 40 10 5 ment 30 10 6 forro 20 10 7 forro 10 10 8 forro 5 5 Starting from C2, the column C has a formula (=B1-B2) result = 40; (=B2-B3) result = 30; etc... When I apply autofilter the formula in cell C keeps the original info... 27 Apr 2010 21:20
Need solution for wildcard use in array I need to find a solution for the following formula to be used in an Excel worksheet in Excel 2003: =SUM((('GCP Vendors'!L3:L999)="*Other*")*(('GCP Vendors'!O3:O999)= "Consultation")) I need to count the number of times a cell contains the partial string "Other" in the L column and then sum up how many of t... 27 Apr 2010 16:49
Formula to fill one cell from another I have a table of data based upon the 12 months of the year, one month per column. Other data is added to the spreadsheet with associated month numbers: e.g., 124 for 1 (January), 34.5 for 4 (April), etc. This other data comes in sequentially; i.e., if there are only 3 months of data, they will come in three ... 27 Apr 2010 15:40
How to? I have a work sheet that has lots of prices from things that we do and I am wanting to put it into a page where if say B4 is Cookies then the price for Cookies automatically pops up in C4, but I dont know how to go about doing this. Please help. Excel 2007 ... 27 Apr 2010 15:40
MSN Stock Quote We have a worksheet setup that uses the MSN Stock Quote. For the most part, the worksheet is fine. However, a few of the symbols are not able to be found. I know that the formula is working because I can use a different symbol and the information populates. However, for a few we are having a problem. Since... 27 Apr 2010 14:30
Significant digit causing wrong value? I have been using a simple IF formula w/o any problem for several weeks until now. The IF statement just calculates the amount of product from a meter every week. This simple formula compares the 1st of the week vs the last of the week readings and even if this meter rolls over this IF statement calculates ... 27 Apr 2010 15:40
How can I lookup when match has more than one value? I had a question re duplicates as well: I am trying to do a vlookup matching number figurers to their corresponding year. However the years are duplicated: Jan 1990 5555 feb 1990 4555 Mar 1990 4444 Jan 1991 54487 Feb 1991 2255 And so on... i have a separate table with just the numbers. I... 24 May 2010 05:49
add two cells from seperate work sheets into a cell on seperat Hi Gord, I know the difference but I wasn't sure what he try to say, it happens to me last year somebody giving the same description and was refering to different workbooks, this is why I asked if he means different files "Gord Dibben" wrote: Eduardo Maybe you should check out help on the difference... 27 Apr 2010 14:30 |