We need a formula to do the following: Subtract a given reading from the one previous to it and divide it by the number of days in between. That average number...

I have a database prg. from which reports are export to Excel. But there is a particular report that shows code instead of actual headings. Let me give...

I am hoping all of you smart excel buffs can answer this for me... If I have a chart with COLUMNS labeled... 1) Name 2)price 3) category How can I have all...

I'm currently rying to put together a work sheet which will allow me to input a date of birth and todays date to give me age today to the nearest 1/2 year and...

Greetings, This should be simple, but the solution escapes me. I have a fixed length column (19 Rows). In this column I have a list of names, I use a formula...

I'm trying to figure out how I can automatically have data inserted into one worksheet copied to another based on an identifier. For example...In my first...

I cannot seem to get Mr. Bebans formula to work....I enter the simple formula as he described in a cell. It is bringing back only the first occurance. ...

I am sure this is out there somewhere...I just can't find it. A B C D E Cage Box Kennel Dog 2008 ...

Below is my formula...there are #DIV/0! in the data set...(I can't remove). I want to exclude them in the formula. Basically...how to I exclude the #DIV/0!...

I have found the PULL code for updating links in closed files. However, does anyone know what I need to do with this code? I pasted it in the code area of...

I am trying to create a formula that looks to another cell with a file name in and return the result. Example: =vlookup(A1,+Sheet1!B6,4,false) Where...

I know this answer is out there somewhere...I just can't seem to get any to work. What I want to do in Sheet1 is lookup cells A1,A2,A3,A4 in Sheet2 cells...

What I would like to do is, within Excel, create a list down one column of all the file names within a certain folder. Listed with the filename, somehow, I...

I am trying to ultimately do a lookup...I will word it out so as to explain my goal....If the 1st 5 digits of the number in Cell A1 equals the 1st 5 digits of...

I found a solution to my problem.... However, to designate "or" between multiple conditions existing in a *single* range, you can create an array of these...

Hello, I have a formula working where I am looking for a Match of one item...I would like to add 2 more items that need to match. Is there a way to add...

Here it is: car bus eat walk box cat rug talk apple pear fruit 5 10 15 20 apple corn fruit 7 3 2 4 I need to...

I have a date in cell A1 of December 1, 2005. I do a =text(A1) and it returns December. I want to now get November, October in other cells based off of the...

I have a column B of names that is part of my sumproduct formula...there are some cells in this column that contain #N/A. I have to be able to complete the...