I have created a formula that uses a lookup table. I want to copy this formula and paste it into cells in a column. However, the refence to the table change...

I am in need of a formula that will calculate a months worth of salary. I am currently using =(annual pay/12)x1 This is not calculating correctly. Thank you...

Hi, I am facing a problem in excel. I have a database on website in that i have a column of credit card. when i export that data in excel format all column...

How to add a theme color to the drop down of the fill color? Thanks

I have a dashboard type of display on worksheet #1 (Dashboard) where an individual updates a cell B3 through out the day, everyday, with a new value. On...

How can I use a formula like: =SUMPRODUCT(--(Jan!$H:$H=$A3)*--(Jan!$J:$J=B$1)*--(Jan!$J:$J=B$2),Jan!$J:$J) for multiple sheets? Following formula is not...

Hello A report is send to me has 27 columns and at least 900 lines I need 3 columns column a name of customer column c has type of transaction ...

Dear all, I am facing problem in SUMIF formula and problem is: I have applied SUMIF formula and linked with another file not, when I try to open this file it...

Can I edit my old spreadsheet using the new features? I don't want to re-do the entire spreadsheet!

Is it possible to let excel return a formula instead of the cells value. At this stage I need to write all possible formula's for each cell (vlookup will...

Can Office 2007 open lotus files? -- Mike Tintle

Hi all, I am using excel 2007. I have one excel file in which I had few graphs. I deleted all the graphs and charts as I wanted to create new one. Since I...

Excel2003 ... I have approx 90 WorkSheets ... Cell D6 of each worksheet contains a value I wish to capture in a single worksheet Col. I can select each cell...

In Ecel, can the cell-pointer highlight the entire ROW and COLUMN as it is moved around the spreadsheet? It currently highlights the borders, but it would be...

All, I have a spreadsheet that has 160,000 rows and I am having trouble with the incorporating the fill handle to fill down values on a new column based on...

I have a column with 144 rows. In alternating rows, I have a solid fill to make the spreadsheet easier to read, especially when printed. However, when I...

I am experience a problem when copying worksheets. I have a workbook with about 9 worksheets. The size of the workbook is about 1 MB. When I right click on...

Why doesn't the union reference operator work below? Suppose J24:J28 contains 11,20,31,43,53, and K24:K28 contains the text grp1,grp2,grp3,grp4,grp5. And...

Thank you in advance I have 2 different spreadsheets of about 18000 lines each of products. The item codes on sheet one muct match the ones on sheet 2....

I want to create a workbook such that users can enter data (using a data form like page) but once data is entered, it cannot be changed on the spreadsheet. I...