Hello, I have 2003, I'm trying to color cells that have specific words w/in the cell. I want to count words like "*broke*" and "broken*" as the same to get...

New to this. Sorry if very simple question. I'm using a laptop and the suggested method of inserting static date and time of hitting CNTL+ doesn't work. ...

This is probably very easy, but im having trouble - I want to find a formula that does the following IF H49 + G49 = F49 and F49=I49 then True If it...

Hi I run Excel 2K Conditional Formatting in Excel 2K only allows three conditions to be applied. I need 8 conditions. What I have is 8 check boxes that...

For a family budget how would I calculate monthly gains/losses in Excel?

Hi guys, is there a way to convert the following 123456789 to 123-456-789 or abcdefghi to abc-def-ghi I need to convert a long list of serial numbers so I can...

Is it just me, or are the AND and OR functions reversed logically? Is there a tutorial somewhere on how to use them? The help files in Excel are their usual...

I've used vlookup for a while now in the office 2003. Just converted to office 2007. Now when I do a vlookup I get the formula displayed in my current cell...

I am attempting this for the first time and would appreciate help. Thank you.

Hi, I am using Excel 2007. Headers on my first page (in Columns A3, B3, C3, and D3) are as follows: Date Test 1 Test 2 Daily Average I would like...

Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of...

This formula should work: =AVERAGE(OFFSET($B$2,(ROW(A1)-1)*3,,4)) this averages range B2:B5 copying down will automatically change it...

In one colum I have different years eg. 2009, 1979, etc.. In the next column I have 2010. What I'm trying to do is subtract from each colum to show how...

I need a formula to convert 15 minute timestep data to hourly average (an average of the four 15 minute data points for the hour). My spreadsheet looks like...

This is Microsoft Office 2003. I'm typing out end-of-year audit for accountant. sometimes when I type in a number in the column,it changes to bold...

I have both first name and surname in one cell, ie. Mary Byrne and want to sort my list of names by surname first. Is it possible to divide the cells into...

Could you please elaborate what is the function of Control Find and Replace. Especially when using it to replace a formula to a new coloum

MS Word allows you to go to FONT, TEST EFFECTS and make the text "blink" on and off. Can you do the same in MS Excel?

I have a pivot table. The columns are month and rows are sales people. I want to display the grand total for the current month from the pivot table in another...