I posted earlier as a Novice, but have since reduced myself to idiot status. Working on our budget for 2006, which up to now is largely a manual process. We...

Can I have get column A - F rows 1 -30 be a certain width then have column A - F rows 31 -60 bedifferent widths?

I am trying to use Excel to do my manpower allocation and planning. So I have a column of employees and a row of months. I then put in the project name that...

Example : week 5, customer ABC's requirement is 100,000 pcs of 1U, 30,000 pcs of 1T, 60,000 pcs of PP, 1,000 pcs of 2T and 1,000 pcs of 1C. Under such...

Hi All I am trying to use conditional formatting to show the difference between a due date and a forecast date. For example, if the forecast date is up to...

I am using VLOOKUP as part of a SUM array formula like this: {=SUM(VLOOKUP(A9:A10,COLORTABLE,2,FALSE))} I was expecting that this would lookup the value...

Hi, I am not sure how to accomplish this task. I have multiple columns of data. I am locating a value in a column (F) on the right using vlookup to find the...

=LOOKUP(M11,{0,0.98,1},{0,"$750.00","$1000.00"}) This formula works fine if M11=100+%. However, it's not working when M11 = 98%. Help! -- News Gal

I have a column of cells which contain some cells with values (ie: 4,6,3,5,7 etc.) and some blanks (cells which possibly will have values if circumstances are...

Hi - Can anyone identify & rectify the error I gave this formula at Data-validation-List ; Source results shows first item of next range...

Hello, In cell A2, I have coded the formula "=NOW()". Sometimes I have to hardcode a date from an earlier month in this cell. I wanted to use conditional...

The regresssion tool says the limit is 16 x's. I have 30.

There has to be a way to hold the numbering format in excel spreadsheet when it converts to data source for mail merging. Help!

I would like to have an auto updating date for a timesheet. At the start of the week the date would show the date at the end of the week. At the start of each...

I have a small but frustrating problem with an excel formula. I have a formula that is adding a bunch of cells (cells are not in a range). The original...

I have got something like: =IF(OR(AND(J3B3,J3C3),(AND(J3E3,J3F3)),(AND(J3H3,J3I3)),TRUE,FALSE)) In words, I am trying to say: IF the value in X is...

I am trying to enter a formula in a worksheet. I want the formula to do the following: IF A1=40 then enter 1, if less that 40 enter 0, OR IF A1=45 enter 2,...

I created 43 sets of workbooks that need to be locked and protected from end users. I have created a macro that will clear the previos days numbers and copies...

I have column headings for DATE, $RATE,UNITS PER WK,NUMBER OF WEEKS, TOTAL. At the bottom I have cells for JAN, FEB, MAR etc. I want the month cells to...

Hi I receive requisition spreadsheets that I want to populate and reply to the sender or senders. Currently I need to open the sheet, enter info, save and...