cell m2 refers to a letter determined by a formula.(for exmple D or F). cell i10 uses the following formula with a cell reference to another sheet. I need the...

help me plz if you see one of the templates like balance sheet in excel some of the cells are deactived and users just input data in special cells. so how...

=SUMPRODUCT(--(MONTH($O$11:$BN$11)=MONTH(DM$11))) -- Regards, Peo Sjoblom "BeSmart" wrote in...

I have a column of approx 500 cells containing text. I want to be able to count the number of cells cointaining text beginning with * for example. I.e....

13 teams, saved team players in pivot table format (also first time user for pivot...

when i transfer an excel file that contains =convert formula when used on a pocket pc the formula is stripped away - why is this ? is there an add in for the...

I have a worksheet ("Winners Log") which has a list of JPEG numbers in column A. I want to click on any JPEG number, have Excel find that JPEG photo in the...

When I have a large amount of data being fed into merged cells, wrapped text dissappears after roughtly 1000characters. Is there a way to change this? As...

I'm trying to format my spreadsheets so that when I'm working with numbered lists, the numbers stay in sequence. If I delete or add rows or if I type a number...

Hi , I am trying to copy an entire spreadsheet from one workbook to another workbook. But it only copies the values not the formulas and if I try the paste...

I am having a problem with Excel. One column in particular is a "number" formatted like “text�. Some of the cells say they are formatted as text, but...

I have a large sheet with about 1000 rows and 9 columns. I want each blank cell to be filled with a color i specify (lets say yellow). How can I do this with...

Is there a way to set conditional formatting to respond when a cell contains the text "msg" somewhere in the body of text in that cell?

Dear, Since a while ago (when it still worked) we begin to have problems with one Excel-sheet and Custom Views. The problem is that when we apply a custom...

I'm having problems retrieving stock quotes. I'm following the directions (typing symbol in cell in all caps, then clicking outside the cell), but only...

I found that when trying to apply the INDIRECT function to a Named Range that defines a multiple selection range, it doesn't work. Does anybody know anything...

hi, i have a spreadsheet with about 4 columns of data. while recording a macro i deleted every cell in the 4 columns of data. i then had a button and i assined...

I am clearly not understanding how to use the formula in conditional formatting. Here is what I am trying to do: Cell B10 copies the value from Sheet2!Z100. ...

I would like to track production start/stop times and then convert the total time to minutes instead of hours and minutes. I have been using a formula like the...

Hi I need to find how to work out the total number of months where I have a list of fixed start and end dates, always beging on the first day and end on the...