I have an excel spreadsheet with several columns. To verify that data has been entered correctly I have a column that adds all the columns and should equal...

I need a formula that will enable me to count how many of each product there is. For example in one column there could be five different products appear...

I am trying to create a dialog box in one cell which checks value in anoth cell (e.g. yes or no) and if it is yes, then asks for a value number (1-100) and...

Hi, I am trying to use a vlookup or other function to return the value in the amount column based on the location and date. Here is a sample of my...

Hi, I'm doing a report with monthly averages for each team. What I want is when an average number is met at A2,... A3, ... to show "yes" or "no" something...

Feels like a very embarrassing question to ask but here goes. I have a number of sales for a year (C3), and a percentage increase on the previous year (C7)....

(cross-post added to Excel "tsundru" wrote in message ... I'm...

I create a new spreadsheet each month and copy and paste the formatting from a previous spreadsheet. Yesterday I had a security warning that the spreadsheet...

While the technology industry is not immune to the troubles facing the U.S economy, it is positioned to weather a downturn, Microsoft CEO Steve Ballmer said...

Hi, am trying to lookup and match values a simplified example of my data - A B C 1 code name 2 MG1 Name1 3 MG2 Name2 4 MG1 Name3 I am using...

I have an array constant {1000,1.2,2%} in cell A1 S = 1000 P = 1.2 R = 2% How do I reference the array constant to create this formula: =(S/P)-((S/P)*R)

Using Excel 2003. Creating a client list, I want to copy home address to mailing address if mailing address is blank. For example, C2 is home address, L2 is...

I've got a mailing list of around 1000 names, stored in both Word and Entourage like this: First Name Last Name e-mail address Once I’ve eliminated the ...

This should be very easy, BUT can't figure it out. Excel 2003. I have a single sheet with 7 columns and around 550 rows. I made an Index on the top area of...

My question: I have two worksheets. One worksheet has several columns. The second worksheet has one column. I want the information from number 2 worksheet to...

How do I add column headings to an Excel document?

We are using Excel 2003 We created a drop down list using the Data\Validation process, which works fine. When the arrow within a cell is clicked on to show...

Why is this: - it may be as simple a reference such as being in D4 and placing command =C4 and copying it down 1 cell by dragging the corner of the cell...

I am creating a P+L and need a formula for this instance. I am reasonably profficient on this software but have never had to generate a spreadsheet like...

I have the following problems and would appreciate some help. I have created macros to do the work, but unfortunately, it creates absolute references to...