What is wrong with this formula? ='DCFs-Sym'!G87&" ("&SUMPRODUCT(ISNUMBER(SEARCH("RTR",'DCFs-Sym'!J92:J2002,1)))&")" The result should look like this: 1802...

I need to sum an array {=sum(a4:a8/b4:b8)} which is based on two conditions, that the individual cell dates associated with the array range is less than a...

I am making an excel sheet where I need four rows of information about each transaction. Is there a way to sort this information, while keeping the four row...

I am using Microsoft Excel 2008 for Mac. I would like to create a hyperlink from a "summary tab" that will link to other woksheets in the same workbook. It...

Hello, I wrote the following...

I'm having a problem with the find and repalce fucntion of Excel. I have a simple worksheet tht has about 20 cells that are linked to another worksheet. ...

How do I create a blank space/row at the top of a drop down list?

How do you automatically fill in values down a spreadsheet. I have a formula in cell A1 that references the value in B1 (ie ="text"& B1) When I enter a...

Using 2003 I like referencing the path & file in the footer of my spreadsheet, so I use &&. Is there a way to reference the path, file AND the sheet...

I want to assign a different value to a number in order to weigh a ranking, ie: 1=10. Can I do that?

I built the following macro on Excel 2003 SP2, It ran on 2 other network computers running Excel 2000 until just recently, one computer was replaced and the...

Hello. I used the following formula to highlight numbers in Column B which were not in Column A: =(COUNTIF($A:$A,B1)=0)*(B1"") Now I want to resort...

I am trying to deliver an Excel Spreadsheet to my boss that will open up as soon as he logs into the network. The worksheet tracks projects and provides...

How do you automatically fill in values down a spreadsheet. I have a formula in cell A1 that references the value in B1 (ie ="text"& B1) When I enter a...

I have few cells in a worksheet which is of gray color. I am not able to change or remove the color from these cells. What could be the reason, and how can i...

We develop excel documents that has several workbooks that have links between them. During the development by one team, the links are developed between...

Hey guys, I have a file in Excel 2007, saved as XLSX. It's just few sheets with prepared borders and some filling. What is the point - I need to send it as...

Office Excel 2007 - latest updates. I want to place my cursor in a cell $D, run my macro and have it: Delete 3 rows (entirely) above my selected cell...

How do you automatically fill in values down a spreadsheet. I have a formula in cell A1 that references the value in B1 (ie ="text"& B1) When I enter a...

col a col b 103 100 204 500 need to sum col b based on the first left character of col a ie 1 100 2 500 -- Bonita