I need to enter dates as they appear below. That's correct, double entries for each day. Is there a function or code for getting this done this...

I want to take the results of a fromula on one sheet and use it on another sheet. I want to know if I can put a formula in that can draw information from...

I have a table of data arranged as below: Parent Name Prod Type April Sales Company A Wood 2,833 Company A Wood 2,150 Company A Wood 4,872 Company B Other ...

The color gradient that looks like a sunset is available in the charts when they are added to a worksheet. I can't seem to find the same 'gradient' color...

I'm working with inventory where drawing numbers have leading zeros. I need to lookup the drawing number from a different sheet and return the correct part...

I want to use Excel to evaluate the results of a psychometric test. The test produces pairs of figures. Each figure can be positive or negative If both are...

I have an IF statement that is as follows: =if(a1=99%,"yes,"no") What I would like to see is if cell a1 is blank, then neither "yes" or no" are returned, the...

Working on a quote worksheet, with several items and prices. Simply will only enter certain qty's by certain items and the extended cost will be calculated. ...

In an Excel spreadsheet how do I stack the type in the heading of a column? Example.... Stacking Excel Type Anyone out there that can give me an easy answer?

Hi, I am using Excel 2000. I have created a worksheet in which some of the cells have validation lists. I have protected the worksheet and unprotected the...

I am adding check boxes to an Excel worksheet - I've copy and pasted them to all of the cells I needed them in. I then look at the document in print preveiw...

I want to return a date that is the result of subtracting working days. For example: 05/10/05 - 5 business days(m-f)= 05/03/05. Were 5/03/05 will be...

I sent this before but not sure if it was accepted. I have a worksheet with some cells containing values and some containing values and text. e.g. 1234 or T...

I have a table where I total the number in the column of each specific row. Then I verify by adding the totals together and they are differnet about 1 to 2...

I am trying to create a formula for rent purposes of a hotel. I want the formula to add 7 days to the date for every $75, add 14 days for $150 etc. I know the...

I understand that up to seven IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests. What should I do or...

Hi, I'm having some problems using the INDIRECT function to reference a named formula on a different sheet. I want to be able to put the name of the sheet in...

I am new to VBA Codes and would like to get an understanding of the codes and their meaning. Is there a site I can visit that has the codes and their meanings...

I deleted several tabs (from a previously saved) spreadsheet, and inadvertently clicked save, rather than "save as", and overwrote the original file. How can...