General

Discontinous values in a column
How can I fill in the empty cells in a column like the following : 4525980367 4525980560 4525988472 4526001271 4526005001 4526026221 4526051700 4526082664 4526131807 4526155800 4526174165 4526288621 4526336940 4526383124 4526384755 4526412139 4526454480 4526461206 4526463275 ... 24 Dec 2009 04:17

When dividing by 0 can i show a result of 0 instead of #DIV/0
I have a formula that divides the quantity in one cell by the quantity in another cell to give me a result in a third cell. It's designed to give me labor rates. The problem is if I have a particular item I don't need the rate for it I type in 0. That give's me a#DIV/0 result. Is there a condition I can use if ... 27 Dec 2009 15:13

Conditional Formatting
I'm trying to conditionally format a cell so that if it contains what cell $K$5 says, then it will be colored a certain color, if it contains what cell $L$5 says, it will be colored another color...but to be colored it can contain more than what is in K5 and L5, as long as K5 and L5 are in it somewhere. Make... 23 Dec 2009 15:11

2 rows of information, need to move to 1 row
I have a spreadsheet that gives me a row of information for each dependant that an employee has on file. Ex SSN FName LName Dep FName Dep Last Name 111-11-1234 John Doe Debbie Doe 111-11-1234 John Doe Donna Doe 111-11-1234 John Doe James Doe I want to move the... 23 Dec 2009 17:26

Excel count with 2 conditions
I'm sure this is an easy one for you but I just can't get it to work correctly. I have a spreadsheet that I want to count certain criteria. Example: A B C Name Gender Score Calvin M 3 William M 4 Jessica F 1 Sarah F ... 23 Dec 2009 16:18

Denormalized data in Excel
Hi, I'm not an expert in Excel, but I opened an XML file in Excel, and modified and now I'm trying to export it out. However it is telling me that: ____ is not exportable because it contains the following: Denormalized data I do not understand what the above is telling me. A sample XML file can be found ... 23 Dec 2009 09:43

Unable to Unprotect a 2003 .xls file
My company recently upgraded to 2007. I had a file that was protected and only certain cells could be modified, for data entry. I now need to manipulate the file but I am unable to unprotect the file. The “unprotect sheet” button is not available. How do I unlock the protection? ... 22 Dec 2009 12:37

Drag and drop data only??
Hello, I am working on a very large spreadsheet and need to drag and drop large amounts of data. The problem is that when I do this is drags and drops my borders also, leaving the empty cells with no borders. Is there anyway that I can drag and drop my data only? ... 22 Dec 2009 12:37

EXCEL 2007 VERY SLOW WITH LARGE DATA CHARTS
I am experiencing the same problem as Joelle. It hasn't always been this slow. It is slow with all types of speadsheets (large, small, complex, simple, new, old, etc.) Copy/Paste is particularly slow. Blue circle seems to spin for ever on "copy" and then again on "paste". I do not have Google desktop instal... 20 Jan 2010 01:52

SUBTOTAL
Hi, I have subtotal at the bottom of a spreadsheet and is used when filtering on a group of rows. I have a problem that if I change the subtotal row or chnge the format of the cell it stops appearing in the filter. Why is this? Thanks ... 22 Dec 2009 05:59