I am wanting to know the row number in which a VLOOKUP result was found. I know I could have a column containing the row number, and return that as my...

I am trying to fill down a colum with this formla =COUNTIF('Group 1'!C9:C2168,"B") the next line should read =COUNTIF('Group 1'!D9:D2168,"B") .. But it...

Please Help. I am a teacher of grades K and 1st. I have all of my students listed in column A There Grade K or 1 in Column b. I have the test that I have...

Excel 2007 I have a spreadsheet with columns for each day of the week. The spreadsheet is broken down into 5 sections. For each of the 7 columns I would...

Hello, Here is what I am trying to do. I have 50+ worksheets within a single workbook. I am trying to gather certain data, by date, that was inserted from...

What does the "--" do in this expression? =SUMPRODUCT(--(A2:A6="Active"), --(B2:B6=10),--(C2:C6))

I exported a file out of Salesforce into an excel worksheet - in 2003 version I could easily remove the auto filters on each column, however I can't seem to...

I'm trying to create a formula to count text in two different columns for instance: Samle work sheet: A B Jon ...

Using the INFO("directory") function returns the correct path when initially created. However, if the workbook is moved, the resultant value still reflects...

My workbook has 16 tabs in it. The largest tab has 710 rows of data and 30 columns. There are several vlookups going on in the various tabs, but the...

Here's a common example: you want a formula with a VLOOKUP which either looks up the number you want, or returns zero if it's not in the table -- this is so...

I have produced a risk register in Excel. Each risk is anaylsed and ends with a calculated risk factor (a number between 1 and 400). I have used conditional...

I have a document and cannot see the top to edit. If I go to print preview, it is all there, I have no hidden rows, but the header does not show.

Excel 2007 was recently installed on my computer at work. The problem is that I had several workbooks created in an earlier version of excel and now when I...

I need: If column X is blank, use the value in column U; otherwise, the value is 0. I wrote: =IF(X3=" ",U3,0) Unfortunately, it's returning 0 for...

I am trying to create a formula where if C390 then add c7+ C8+ c9 and place the result in cell c37. I know this is not a difficult one but I rarely do if...

This is what the formula would look like if I could type it in this way. Just need help with translating to excel. If cell E1 ("the child's name") on sheet...

on a worksheet of timings, adding TIME through midnight calculates ok, but subtracting time through midnight results in an error - any ideas on sorting this?

I have a sheet with name in column A and values in column B. Every 4 rows it repeats. Each 4 row seccion is a new day. EX DAY 1 Tim 3 Jim 2 Dan ...

I have random numbers in A column I want a formula for conditions given below Percent Point 76-100 1 71-75 2 66-70 3 61-65 4 56-60 5 51-55 6 46-50 7