Functions

Populating Row with dates
Hello, I am attempting to automatically fill a row with dates. In Cell A5, I enter the first day of the month eg 1 April 2010. I then want the adjacent columns to automatically fill with the subsequent dates eg cell B5 is 2 April 2010, cell C5 is 3 April 2010 etc, It must only fill upto and including t... 30 Mar 2010 22:59

Custom Formating Letters to Numbers while Displaying Letters
I am trying to accomplish this in terms of letter grades corresponding to number grades. How do I format a cell so that I can enter a letter grade: A, A-, B+, B, etc. and the corresponding number: 4.00, 3.67, 3.33, 3.00, etc. to each letter grade will be the numeric value of the cell (which I can reference in a for... 31 Mar 2010 14:22

How to convert 115:14 into hours? ( 115 stands for hrs, 14 is minu
... 30 Mar 2010 21:52

excel conditional formatting
I need to write a conditional formula that will result in a highlight of the cell if the cell value is not one of these three "yes", "no", or "N/A". Can't get it to work. Can anyone help me. -- Vic ... 1 Apr 2010 09:03

Help? with extracting unsorted data from a worksheet, no blank
I went to the page you linked: http://office.microsoft.com/en-us/excel/HA012260381033.aspx The page referred to the command: enter the following array formula (CTRL+SHIFT+ENTER) However, nothing happened when I pressed those keys together. The formulas could not be entered without Excel saying there were err... 30 Mar 2010 19:35

Maintain lowest value in an "external connection" cell
Hi, I have a spreadsheet with DDE macros that draws stock quotes from my data provider. One of the fields is for the lowest price of the day. Now, I'm trying to track stocks over 5 day periods - is there any way to program a cell so it keeps track of the lowest price over the 5 day period? Say for example, ... 30 Mar 2010 19:35

index, match in array setup question
good day, i am working on trying to do an index/match within an array. the formula i have is: =INDEX(Sheet1!C:C,MATCH(1,(Sheet1!A:A=A5)*(Sheet1!B:B=Sheet2!B5),0)) with the { } around the formula. the problem that i want to over come is as follows: on the worksheet that i enter the formula, column A (cell... 30 Mar 2010 19:35

Return range of cell values based on current date
I have a spreadsheet containing daily sales data for the month. I want today's sales data to display on a different worksheet to save the hassle of someone scanning through an entire month of data. Is this possible and what function do I use to achieve this? Thanks, Wing ... 31 Mar 2010 15:29

Automatic recognition of a starting point for a column calcula
replace the v90 for the INDIRECT("v"&MATCH(SMALL(W:W;1),W:W,0)+5) sorry -- pleae click yes if it was helpfull regards from Brazil Marcelo "Marcelo" escreveu: try this =STDEVP((INDIRECT("v"&MATCH(SMALL(W:W;1),W:W,0)+1)):V90) hth -- pleae click yes if it was helpfull regar... 30 Mar 2010 18:25

UNABLE TO SAVE FORMATTING
I changed the formatting on spreadsheet including color filling, add border, bolding fonts, wrap text and merge cells, then I saved the file. Nearly all cells are updated except for one merged cell. When I re-open the saved file, this merged cell with all the above described formats did not change. Please hel... 30 Mar 2010 17:17