I've got two columns (D, E) headed DOB and Age. Basically what I'm looking for is a forumula which looks at D, puts the amount of years in E as...

I replaced the yes with a 1 and the no's with a 2. Is it possible to keep the yes and no's and add up the columnx?

Hello, I have created a workbook that I have locked and left certain cells still editable. I want to be able to insert a row so that the user can add more...

Hi, Do you mean things exactly 14, 24 and 36 overdue or do you mean 14-23, 24-36, 36? Let's assume the first, and that the numbers are in column A, you...

How do I simplify the below string to use in Excel 2003. It works in Excel 2007. Is there an easier way to get the same result? Perhaps vlookup and how...

For the footers on my excel documents, I am requried to include the complete file path. When I email the docs to another user, the file path changes. This...

I have a spreadsheet that contains weight tickets for the month of some/all of my vendors. This information is listed in vertical order with all references...

I need a forumula to do the last column: tell me what weeks the units are arrivng (e.g. 1,2,4) but the catch is that the units need to be greater thatn 25...

I am using Data Validation with a ComboBox from Toolbox. the problem I am having is that my list in the combobox will only scroll 121 rows and not the...

I have a table that is connected to a sharepoint website that I would like to be able to reference throughout the rest of my workbook, and have all of the...

How can we refer to the value of a defined name in a formula in Excel 2003 by combining text with a formula? My formula is:...

Hello, I am working on an excel document and I need to find out the top 10 publications in column E and then I need to match these top 10 against the...

I have created an excel formula with names in it. I have created a set of names and I want to call the names given in the row through formula. 3 A ...

Hi, I'm trying to link one of my worksheets to other worksheets within the same workbook. The source data on the other worksheets is not in a set structure...

I have a table as follows A B C D Start Date End Date Employee Vacation Type I then need to...

I have created a table that displays the weekdays of the month, who has the highest commission and how much they earnt in the form: Date | Seller| Commission...

I have a couple of questions, I am managing 100 volunteers at a conference in Florida and they need to be assigned to sessions/workshops and an exhibition...

"NICK" wrote: I need to produce a list by sevice owner(column b) that will print all the rooms(column a) that fall under each service. please see below ...

An example of what Im trying to do: Four cells in the same column A1:A4 with values 1,2,3,4 respectively. Assuming that the value of A4 factorial, so A4!,...

I need to produce a list by sevice owner(column b) that will print all the rooms(column a) that fall under each service. please see below i.e. Service ...