Is there a formula out there that will sum every nth row? I have a template that has the same measure in consecutive rows and rather than selecting the cells...

I have a worksheet that is populating condtional formatting although cells were not set up as that. It is the strangest thing and I can't figure out what's...

I have cells containing a question mark '?' that I wanted to replace with a blank. When I did a replace for ? with blank it cleared out the entire cell. Is...

I am trying to create a formula and evidentally I do not know what I am doing. I need HELP! I need to multiply any number over 2400 by .02 and get the sum...

I've created a new worksheet which displays individual records from my spreadsheet using a combobox and INDEX functions. The problem is that I lose my...

I'm trying to use the following in my defined names: =OFFSET(Export_Requests.csv!$C$1,0,0,COUNTA(Export_Requests.csv!$C:$C),1) to define a column of names...

I have a table with the headings; job number, title, and option (A/E). I want to pull in the jobs which are only option A into a new worksheet table. So my...

When I try to use Indirect.ext I keep getting an error message stating Can't find project or library Then the projects library window opens. What library do...

I have spreadsheet which is a column of movie names. is it possible to hyperlink to the Internet Movie Data Base info for the move? I tried adding...

Hello All, Here's the dilemma. I have a set of dates in two columns. I can determine the data set from the first column but I can't figure out how to count...

Hi, What I'm trying to do is get a count of cells from one column based on cells that do not contain specific text in another column, i.e.; A B 1 at...

Hi, I have three columns of data. What I am trying accomplish is totals from one of the columns based on the difference between dates, i.e. from the series...

I have a spreadsheet with two series of dates, date_paid and date_rec. The date_paid column has occurrences that are separated by 7 days. What I am trying to...

Say i had a cell (E.g K1) that has a forumla within it which gives a number as an answer. i also have a number of records in the same worksheet e.g....

Good Day: Data Input is as follows: A B C Date Time ...

I have 2 questions 1) Is there any way to link a macro & cell together. For example, i have a cell that has a kind of count down in days, updated every day...

NOT REALLY SURE HOW TO EXPLAIN IT, SO I THOUGHT IT MIGHT BE EASIER IF YOU TYPE THIS IN A BLANK SPREAD SHEET cell A1 type in - 08-Dec cell B2 type in - ...

Cell S12 - =IF((A12)*(A12""),VLOOKUP(A12,'Books Borrowed'!$A$5:$G$35,3),"") Cell A12 contains a value & In cell S12 i get the answer #N/A (I was...

i think this is probally the easiest thing in the world to do but i dont know how. i want to transfer excel files from one computer to another via cd. how do...

I believe this is an excel bug in which I will do my best to explain. Stick with me on this one. I am using Excel 2000 v9.0.2720 I have a column (column C) of...