Firstly I rec'd an e-mail but could not open it, there was nothing there. If whoever sent it could resend it, please. My problem is with EXCEL 2007 - I am...

I am wondering if there is a way to highlight in Conditional Formatting when a Customer 1st hits 1M mark My data is in a pivot table that looks...

Let's say I have values in range A1:A26. Next I have some values in range Z1:Z7. I'd like to do some sort of SUMIF or SUMPRODUCT that if any of the values in...

Conditional calculations across sheets isn't easy. Try...

I've gone through many of the posts which answer queries on the above functions, but haven't found one that I can apply to what I'm trying to do. There are...

I received an excel file that has macros. This sheet has 4 tabs, on one tab I enter in multipliers and it propagates pricing for customers. Not each...

In previous versions of EXCEL there was a way to change the direction of the cell movement (right, left, up, down) after entering data and pressing the ENTER...

I am trying to figure out a formula that will count two separate things in one column. I want to count the blank cells in a range and within the same range I...

We are using Excel 2007 SP1. I am working with an Excel file (.xlsm, it contains macros) that links to cells in another workbook that is in 2003 format. The...

I have a list of start and end times. I need to weed out any hours that fall between 8:00a and 17:00 (5:00p). I've tried several different formulas without...

My worksheet is not a dbase, nor a spreadsheet, but rather a weekly calendar in which I count each individual's hours, yet it has to be in a printable...

My company uses an excel spreadsheet to track time spent in several different programs (ea. program has a number). It's easier to show. The following...

Hi Can anyone help me with this, I want to search a range of cells say B2:B500 a value such as 6523 that is in E2. B2:B500 is made up of a url with an id...

Have used it in older versions of excel but can't use it now. Use it to calculate an age.

can i test a cell to see if it is one of 2 results using an =If(a1="","Unsold","sold") formula and then colour it RED dependant on result eg result is Sold...

I have a large workbook with many tabs. These tabs are linked to together throughout the tabs. Lately the cells have not been automatically changing when...

I have created custom headers and footers. Is there a way to save these custom headers and footers to use in other files? Can they be saved in the...

I have a worksheet that has 6 months of data (2 columns for each month) the first column for each month is zip codes and 2nd column is how many homes sold in...

Cell A1 contains the value = Abw929acp148ab9520cs6528 i.e. a1='Abw929acp148ab9520' the result so required should be: B1=Abw-929 B2=acp-148 B3=ab-9520

I have a worksheet designed to print a certain kind of document. In this case it is gross composition for a product. There are several different products...