Here is another site featured by American Consultants Rx that really helped me and my family deal with the high cost of prescription drugs at...

Hi Guys,Im pretty sure this cant be done but thought id check with the brainstrust.. I have XL2003 and would like the entire row to be highlighted when im in...

Please help! I am trying to figure out how to use the Auto Filter with my merged cells. Here is an example of what I am trying to do. (M=merged, D=data) ...

eI have a table of data (b2:f600). Some of the rows are green, some yellow, etc. I need a formula/macro that will put a number or text in column A based on...

I am trying to extract all the characters after a numerical value in a cell. The numerical value can be any number and at various positions within the cell....

There seems to be a major bug in Excel. I open a spreadsheet in Office 2000 Excel and a conditonal sum gives a correct answer. Open the same speadsheet in...

How can I create a macro wherein the actions include adding a new worksheet and naming the worksheet based on a field in the worksheet? Ex: 1. Add a...

I don't know if this is possible: I would like apply data validation to a range (single column) so that the items in the drop-down list are generated from...

I have a cell (A35) that displays the sum of the cells in range A9:A33. The cells in this range are pre-populated based off another cell's data divided by 24....

I have about 85 excel files that point to 1 single source sheet. However, each file may point to a different cell in the source, and the destination cell is...

Say I have a Cell J2 that contains the Word "Othello" in it. Now i have cells A2-H2 and i want each one of those cells to display ONLY one letter of the...

Hi, I use Excel Workbooks with multiple sheets. I am trying to find out how to have the various cells complete the text I type in. I know it has to be text...

I have a excel 2007 .xls file that always takes several minutes to open. Most of that time is used opening funcres.xla according to the status bar. Sometimes...

I'm trying to write an if/countif function for the following situation: if column L has the 2nd and 3rd #s that are "01" then write "01" in column M if column...

I have a spreadsheet that outlines performance to date by month. The months are listed across a row (D31-031) with text based indicators three rows beneath...

I have 4 columns in a spreadsheet that are formatted for drop down options. I am interested in restricting the selection of options previously selected so...

I am trying to make data from the last used cell in a column appear in another cell at the top of the same column. Another user gave me the formula...

I need a formula that will allow me to show the text in the last cell of a column in another cell at the top of that same column. I have found one that...

Hi All, I have an array with 29 names held in it, I am wanting to do a if statement using the content of the Array. If "MyName" is in ArrayName() Then Do...

Looking for a way to enhance this sumproduct expression to return a unique employee code...