When I type numbers in certain cells on a spreadsheet I get #### but not in all cells. How can I get rid of the symbols and get the correct numbers?

I have a list/column of company names that are receiving product. Within those companies, some are are forfeiting certain quantities of the product to another...

C7 is 38,211 D7 is -2,109 D7 is conditionally formatted as follows: Formula is: =(D7/C7(-0.1)0) (It should turn yellow. It doesn't) Am I missing an...

I have a Macro set up to save a work sheet as a web page and print to a printer on a multiple sheet workbook. I have the same work sheet several times in...

Hi Guys, I just want to ask our experts in excel on how can build a solver template that goes by specifying certain percetage (mix %) for each model/part and...

I have a spreadsheet with one column (let's call it column 1) that has numbers as identifers. In column 1, there may be several occurences of the same...

Example column a = blank column b = blank column c = blank column d = blank column e = will ALWAYS have a number so if there is a number in column e then say...

The match function is not working for me. Please help. I have a calculated cell that returns a number. I have verified that it is in fact a number using two...

I have a template worksheet that looks at another worksheet to get the answers to the formulas in the template. Is there a way to update the formulas to...

When using the filter function in Office 2003, the "drag and drop" method of copying and pasting defaulted to paste only on those cells that were currently...

I have a workbook, containing multiple sheets, and each sheet is named according to an employee's name. Each employee's sheet contains a Customer name in...

How can i add months or years and get the answer in the same format. For example, adding 2 years 10 months and 1 year 3 months. The answer should be 4 years...

Hi all, We are paying the health benefit to our employee on a quarterly basis (calender base). We considered that if an employee joined the company between 1...

In order to help update an existing spreadsheet, I want to be able to count either the number of numbers in a given cells, or alternatively the number off...

In sheet1, I have the following table : Row A B C D Col3 Blank Scen1 Scen2 Scen3 Col4 Smith 12 ...

I have a YTD formula that I need to sum up the values of the same cell in 12 different sheets. When I use the formula Jan:Dec!116 or even put it in Jan!116,...

I have a list of approved vendors (vendor numbers) on sheet 2. On sheet 1, I need Excel to look at A1 to see if that vendor number is in the list of...

how do you countif ... if range 1 ="A" and range 2 = "B"

I want to create a drop down list which depends upon two or three previous drop down list. What I want exactly is to to list down first the type of...

I have data that is ranked on one sheet and I would like to display the data on another sheet in rank order. I.e, On one sheet I have team names followed by...