I have a large file containing data from a golf tournament I run. First row contains player name. Second row shows where they finished. Columns show the data...

I know this is simple, but for the life of me I cannot figure it out – your help would be greatly appreciated!! I need to create a “vlookup� that is...

Can you omit cells purely based upon the color of text when doing this: =SUM(A2:A38)

I have this formual: =IF(D7L7,D7,IF(D7L7,L7,0)) I would like it to round down to the nearest quarter hour as well. I can round in an adjacent cell, but I...

Hi, have collumns with numerical results but also error cells which appear blank due to the formula: =IF(ISERROR((GD17-FE17)/2),"",(GD17-FE17)/2) being...

I have a spreadsheet that looks up certain daily production figures. I would like to update the path or create a path linked to certain cells. This is the...

1. In cell C2 I have a region called East (other regions called North, South and West). In cell D2 I have a revenue of 10,000.00. In F2 I want to enter a...

I have been asked to prepare the benefit projections for 2010 and was wondering if anyone had a template worksheet? We have about 500 employees.

Using the following formula: =IF(ISERROR((BB25-AB25)/2),"",BB25-AB25)/2 But it comes up with #value! errors (some data not available in each BB or AB...

I have a large spreadsheet that I need to protect some rows. These rows are not in sequence or determined interval. These rows contain formulas which I would...

Hi, is there a way to insert Partial background in a particular sheet?

Sorry folks but I am having a brain dead moment because I know I have done this before. I have three columns of data, in column A I have a list of names, in...

Hi, I have a text string and would like all the characters before the | symbol to be returned. The text before the | is varying...

I have looked through some older posts and thought I had found the answer to my problem I'm nearly there but not quite! The start date identifies the start...

sorry if this is a duplicate, but I cannot see the question I posted last night. I need to calculate night shift allowance between the hours 18:00 and...

Everytime i type in 9 - 2 it automatically changes to 09- feb. i changed the number format to general but it keeps changing back to custom. how can i fix...

Dear All, Case 1: A1 + B1 = C1 Condition, if A1 + B1 50, result must be in red color, ex= 51 (with red color) If A1 + B 1 50, result must be in blue...

ANybody can help?

I am having difficulty making cf work in Excel 2007 with XP for an OS. I can open and use files created in 2003 but some of the cf is corrupted because...