Hi, I hope I can explain my problem ok, I need a formula to put in so that I can just input the hrs. and the time worked over or under 40 hrs. a week will...

All of a sudden I can't cut and paste a column of dates without Excel changing the number by one day and several years. ie, 6/30/04 becomes 7/1/05. This...

I have two customer lists. Each lists may contain the same customer but spelled differently. I am trying to identify the customers that appear on both list. My...

I've posted this problem twice already and the next day my post disapears, so hoprefully this time it will stay. Anyway, I hope I can explain my problem ok,...

Hi I have a workbook contains 3 sheets "2002": The first is data for 2002. There are about 35,000 rows of data. Each row has 5 identifying features (ie...

When I divide 100 by 2.4 my answer is this 41.66666667 By formating the cell to 0 decimal points I get 42 How do I achieve 42 in the formula bar and not...

Must be overlooking something simple in the help files. Have two variable criterea: D2 = Length and D4 = Opening Size Chart, as follows: AG96:AL113 Roof...

If I insert a column in the range of a VLOOKUP Command, the range adjusts, but the column index number does not. Is there a work around for this?

Calculation A I am finding a percent score, but I want it rounded to the nearest percent. For example, I want the following result to display as...

I am trying to create a new range that returns data from columns of an existing range without creating a list of blank cells. I used VLOOKUP but may have used...

Calculation A I am finding a percent score, but I want it rounded to the nearest percent. For example, I want the following result to display as...

I would like the specifics of 10 rows in sheet 1 to be copied into rows in sheet 2. Column A will contain the # of items the remainder of row describes. ...

In Sheet1 I have the following formula in B149: =IF(VLOOKUP(A149,MyClinics,3,FALSE),"Yes","No") MyClinics is a named range on my sheet - Reference List In...

I need to count a column of numbers but do not want to count the duplicate numbers. How do I do this?

Scenario: multiple worksheets (sheet1,sheet2,sheet3,etc) sheet 1 is a summary. Sheet2!A1 contains the number 22, Sheet3!A1 contains the number 33 Based on the...

Hi All, I have a workbook that has multiple sheets. Each sheet/tab has a different project name but the cells A:13 - A:19 on each sheet all refer to...

Why is that every time i protect my excel containing pivot table and macros, the excel discard the pivot and does not recognize such?

I have imported some data from the web site. It's using the character code of 160 for the space rather than the character code of 32. I attempted to use the...

Can you please remind me how to hide or eliminate error messages such as #DIV/0!. This appears when a cell is divided by 0. I would like the cell to remain...

i'm trying to set up a weekly workbook. each day of the week has it's own tab. trying to get the dates to correspond to each other. can i set up a formula...