I cannot figure out how to calculate the date for the "next friday" from the current date. specifically, I have a spreadsheet where I want to count the number...

In the MONTH() function, I can get the integer returned OK, but when I format that cell with "mmm" or "MMMM", it always returns "Jan" or "January" no matter...

I want to format the worksheet to look in every cell for a letter and if that letter is present, color the background a color. I cannot figure out how to...

Ben I would combine all 5 worksheets into a sixth worksheet, and then save this sheet as a csv file. I if you do have problems you can always open the...

How do I cant to reading a numerical value of the cell to text Ex: A1 : $123 A2 : $123.50 A3 : $1,100.00 A4 : $109,100.50 The results will be display on B...

Excel - How To Search For A Number In a Cell Containing Several Numbers? I'm trying to determine how to search for a specific number in a cell whaich contains...

Does excel have input masks the same way that access does? I cannot find the function if it exists.

I have a worksheet with a pair of option buttons (Male/Female), both referencing the same cell. This works fine. I now wish to add another pair of...

Hi all In column (I) is numbers, In column (J) is text values with duplicates. What I'd like to happen is if the next same text value working down the column...

I would like to do a conditional sum of a color coded column of numbers. Is there any way to do that in Excel 2007?

I am trying to use a macro from the MS Knowledge base and it isn't working. the macro is supposed to delete duplicate records from a list in excel. If anyone...

Hello, I hope I can explain what I'm looking for. Is it possible to link a formula to another sheet?? I'm trying to use a similiar formula to the "If"...

The quick version; What formula is used to retreive the values from columns C, D, E, etc based on the values of columns A and B? It would be like a vlookup...

One way =IF(INDIRECT("'TestItems'!"&(CONCATENATE("$F$",J5)))0," ERROR", "PROCEED") now the drawback,for indirect to work both workbooks have to be...

I learned that we can change the "save" default path by changing application.defaultpath How do I change the default path of "Save As" command? It always...

newbie question; Payroll in excell, is there a way to make a specific cell containing a date "blink" or flash? Any help would be appreciated. Ray

Hi folks, I'd like to inset a date automatically when ever a cell within a single column is selected. Can I do this?

I am using Office XP in win 2k pro. There is no auto save option, anyway i can have auto save option? Also when i use auto backup option, the backup file...

I have a workbook created in Excel 2002. It consists of 2 worksheets and 1 chart. Certain cells in the first worksheet are formatted to display numbers shown...

Hi David, Just one thought cued specially from your line: .. The output I get is all 3s in the table .. The calculation mode for the book may have been set...