I tried to save changes to a spreadsheet, and received the following message: "Compatibility Report for New Customer List.xls Run on 4/6/2010 19:52 The...

I recorded a macro that sorts data in a certiain way, however sometimes the data is 100 rows and sometimes it's more or less. How can I record the macro to...

I want to compare two sheets: 1st sheet Customer Date of Last Purchase 2nd Sheet Customer Email Address Fax Number Market Segment Rep I want to...

This replicates through hundreds of rows. I need the total hours scheduled by day based on the 0 or 1s in the cloumns , and the # of variable hours in the z...

I have a sheet that has a formula that calculates the dates of cleanings, i have made a conditional format so that the dates that are coming up and past month...

I have the following text formatted as Word Wrap, Text, Top Align, Left Align, but all I get in cell is ############. This has worked in other cells in the...

When I use "track changes" the changed cells are outlined in lavender which is really hard to see. Is there a way to change the highlight color to a darker...

I am using Excel 2003. How do I count rows/column with only text in it. Ex: I have 25 rows where column "B" says "PO Received" in each cell. I tried...

Hello, I have 2 dates, not in any order. I would like to create a formula to give me the earliest date of the 2. Example: A B ...

I have a stock symbol MED in A1. In A2 I have inserted the following link: http://www.investors.com/StockResearch/StockCheckup.aspx?symbol= I want to...

Dear Expert, Got system generated files ... .HSI 0941.HK 2828.HK Is there any functions that can let me capture the content only? That is no "" and ""...

Hi guys, Need some help with this one. My worksheet looks a little like this; Col F Col X Barcode ...

I have the following equation: =IF(J12="Prospecting",X12,"") and this is odd: 1. Prospoecting is taken from a pulldonw list. 2. I just abbreviated the word...

Hi, I'm learning excel on my own and would love someone's help with this problem that I've got. I wouldn't mind if its a couple of helpful remarks or a full...

I am having multiple worksheets in an Excel file and now I want to use the name of each worksheet in a new worksheet in the same file. Is there a formula...

I'm trying to sumif different days of the week. Table is setup as below: A. Date Date Date Date Date ...... B. Data Data Data Data Data ...... I know that...

Is there a formula I can use to change the background colors on specific cells? I want to change the color on the even rows of 4 columns (A:D) to gray. I...

How do I sum cells that have values from a text formula? I have a row of this formula: =TEXT(D6-D5,"h") The only difference in the cells of the row are...

Does any one know how to disable "cut" function in a protected worksheet? By allowing cutting in unprotected cell, it is messing up the formula that I put...

I use Excel 2007 I have a table of about 50 columns and 60 rows. Each row must be compared with the first row of the table: Is there a formula, that counts...