Hello, I have a vlookup statement that, when the table is empty, it returns a - (dash). Dependant upon that vlookup cell, I have the following IF...

I have created some workbooks that are linked together. My budget workbook is linked to four workbooks, Quarter 1 thru 4. I have been playing around with it...

How do you remove the last two digits in a cell using a macro? -- Thanks a bunch! rojobrown

I have two spreadsheets and want to link info from one sheet to another. I have totals at the bottom of columns and I want to be able to put those totals...

Hi, I have a worksheet full of data (Actual DT)with cost centers in column A, subaccounts in column B, and data in columns D through O (each column is a...

Excel 2007 How do I make a range of cells values from 100 to 500 with increments of 5, i.e., 100+5...(100 105 110 115 120...500)

I am trying to assign codes to one of my worksheets based on pricing. The problem that I am running into is that the data that I am taking my information...

When I autosum a column I am getting an overcalculation, $65,388.28 which is incorrect. The correct # is $63,827.50. This correct number is acheived by...

Hi guys, Here's a challenge I hope you can help me solve. Say I have a table of values with X and Y headers and a 3 x 3 array hoding parameters that are a...

Can anyone tell me why this IF formula isn't working? =IF(D5E5F5,"A",IF(D5E5F5,"B", IF(D5E5F5,"C",IF(D5E5F5,"D","F")))) It's returning "B" every...

Hi guys, Here's a challenge I hope you can help me solve. Say I have a table of values with X and Y headers and a 3 x 3 array hoding parameters that are a...

Totally lost on this one. I have a date values in Col I that are fed in from another sheet. These dates may be typed in by a user in any format, but the...

In Excel 2007, frequently when I click in one cell, the program will select that cell plus 2 or 3 cells immediately below the cell I wanted to select. This...

I have a spreadsheet containing daily sales data for the month. I want today's sales data to display on a different worksheet to save the hassle of someone...

Hi, I have a worksheet that has hundreds of formulas and many of them are generating a #DIV/0! error. What I would like to do is creat an IF function in...

I have phone numbers in two different formats: 1. 1-123-456-7890 (11 digits w/dashes) 2. 1234567890 (10 digits only) How can I convert the first format into...

I am trying to accomplish this in terms of letter grades corresponding to number grades. How do I format a cell so that I can enter a letter grade: A, A-, B+,...

Hello all. Sorry if I am posting this question in the wrong category, but this is my first post here. I am using Excel 2007, and I am trying to...

Is there a way to look at a group of records where some have been duplicated and for those that are duplicated , keep the most current date (keeping that row...

Actually, the idea I had was sparked by a more comprehensive explanation I found...