The problem i have trouble with is the formula in getting the letter mark for each of Faculty. I am not familiar yet in using the Match and Vlookup Function,...

I need an Excel formula to convert a date (mm/dd/yyyy) to a serial number, i.e. January 1st = 001, 1st February = 032, 31st and so on to December 31st = 365...

I have a sheet with a number of links to another worksheet. What i now want to add is automatic colour change in cells dependant on input from another...

Yesterday I saw an Excel function that had two hyphens "--" before the function name. I do remember reading about this a few months ago but I do not remember...

I am trying to make numbers entered into a column subtract from a fixed cell which contains an allocated total, and as the numbers are entered into the...

I need to be able to add an apostrophy in front of numbers in a range of existing cells without having to type it into each cell. I am trying to set up a...

I have a column of dates and then I have a column called Date Sequence number. I want the sequence number to start at 1 and increase by one on each row until...

I have a spreadsheet with data from a1..j266 listing all of our injuries by Rig no. and dates, etc. I want to pull the latest injury date per rig. I have a...

I have a column of dates then I have a column called Date Sequence number. I want the sequence number to start at 1 and increase by one on each row until the...

I have two worksheets: The first sheet contains date ranges that relate to specific "Rounds": Start End Round 3-Apr-10 15-Apr-10 ...

Looking for some help, using this formula =INDEX($N$2:$N$24,MATCH(1,INDEX(($L$2:$L$24=$L28)*($O$2:$O$24=N$27),),)) (which I'm a novice at) I'm able to...

Hi All, I am having to workout my companies telephone bill to make sure the carrier isn't charging more than what we agreed, I have done a few calls manually...

I would like to keep a count on the amount of entries in a worksheet.

I'm sure this isn't hard. Brain won't cooperate today. Going home. Had enough. Column A is text (Location code) Column B is numeric (part number) Column C...

opening a file from Excel 2003 into 2007, after making changes and saving in 2007. Reopen file and changes have not been saved

I am familiar with COUNTIF - I am trying to count the number of times "x" appears in the same cell of 7 different worksheets in the same Excel...

I didn't know where to ask. I've attached an excel 2007 worksheet to help show the problem. Please point me in the right direction if someone could please. 1)...

Excel 2003 Given two worksheets in a .xls file. First worksheet is lookup data. First row of each column is a group name, say GrpA, GrpB, GrpC. Under each...

I am trying to write a formula so the if the current date NOW() is between 08/01/09 to 09/13/09 then put 200 otherwise put 0. See formula below. It works...