I'm using Excel 2002. I have a spreadsheet with several function cells. When I open the sheet, I get a circular reference message. It doesn't tell me where...

Is it possible to delete information in cells from a certain column by changing the information in a Cell from a different column using a formula? Or does it...

I have a colunm that I want to sum. The problem is that each entry looks like this: Total: 80.60 Total: 95.00 Total: 84.75 The SUM() function doesn't work...

I'm trying to get my "daily" totals on one sheet to total on a "weekly" sheet. What I want is for, ex. January 1, 2007 - January 7, 2007 = "Week 1" and to...

I'm very new to this area of Excel (i'm still studying at school) and i was wondering if anyone could help me with some code to help me. what i want to...

How do I setup a formula where the equal command checks only the first letter or so. For example, I have a list of companies that I want to screen...

I keep getting a #VALUE error when trying to divide two cells. They are both numbers with decimals. In the error, I click to "show calculation steps" and see...

I'm using Excel 2002. When I click the up/down keyboard arrow keys to move into a different cell, the page moves up/down. The arrows use to move focus from...

Greetings to all I have 12 distribution areas that are divided into 4 subregions. each. My spreadsheet is arranged as follows for each area A13 area...

I would like to use this formula: =SUMIF(F7:F19,"=E54",D7:D19) But it doesn't seeem to be working. Basically, I want to determine which cells in...

I work in an office where we share an excel spreadsheet. Comments are made on different projects we are working on. I need a formula to show when a comment...

I have a multiple Worksheet Excel File with a curious problem on one Worksheet Only where the In-Cell Dropdown has suddenly stopped being Displayed for All...

I am working on projecting some data that is non-linear. the TREND function gives me a line that is too conservative in its estimates, but GROWTH gives me an...

Is there a way to replace #DIV/0! with a zero? Thanks, Brett

If I divide two negative numeric cells and put the result into a percentage cell, it will positive, even if the change is negative. For example: A ...

What I am trying to do is return a certain value in a cell if the value of a different cell is within a one month range. I am currently trying to use the IF...

Hello, I am very new to Excel and have a problem I'm trying to solve. I think I've figured out how to use the nested IF function for normal problems but this...

I receive a huge list of data results from a supplier weekly with a varying amount of rows of data. In the first row there are all numbers, in the second row...

I have a column of data containing 100 cells, every 5th cell is used for comments. I can concatenate them into one summary cell with a line return as...

I'm using MS Excel 2003 SP2. I've inserted pictures using the Insert / Images / From File option. My pictures disappear when I scroll and the picture is...