We've got two excel workbooks. Workbook A is the master. Workbook B has cells that point to cells in workbook A. So, when data changes in A, the values...

I need to consolidate data from 2 columns. Column A has over 40,000 unique values, Column B has only 5. I need to consolidate Column A into ranges. I.e. 1...

Just looking for opinions regarding 3rd party applications and software for easily comparing Excel files and spreadsheets. When one Google's "Comparing Excel...

I have seen a couple of times Excelsheets where drop down filters exist in e.g. cell C2 for the range of cells from C3:C27. So when in den cells C3:C27 value...

I am using the following code in excel 2003. It works fine. When I try to use the file in 2007 I get this error: Run-time error '1004': "Unable to get the...

I have conditional formatting being applied as follows: Conditon 1 - IF(ISERROR(BE97/R97),0,BE97/R97) is or equal -9.5% Condition 2 -...

I see the formula for calculating annually compounded interest. Is there a function formula for daily compounding of interest? RickS

Is there anyway to customize a user exit warning/reminder to a workbook? For example, "Did you verify volume and price?"

I need to be able to find the max value in a spreadsheet and highlight(bold) that number. I need this to happen even when new data is entered

Can I set up excel to import all my data as text columns instead of general columns? The wizard almost always changes some of my data and I would prefer to...

In Excel 2007. From the following example: A B 1 3 2 7 3 5 4 10 5 12 6 8

I am entering names of clients as we enrolled them in our program. Is it possible to have a formula in a column next to the column where I enter the names,...

Hi, Can you please tell me how to put a symbol on a line, if a time is before or after a specified time. I have tried the following which is a valid formula,...

After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I copy just the subtotal

I have pasted data into an excel spreadsheet, but the data is on two different lines ex: A6530 COMPRESSION STOCKING BK18-30 A9900 2 PAIR $ ...

I have an input template in Excel 2002 that other users will update with information. I want to make sure they input a description beside the number. How...

How do I turn off number rounding. I have reduced the decimal place to 0.

Hi all, Can anybody let me know the shortcut key to align the data in cell in excel. i.e. how to make left/center/right align by using shortcut keys. Thanking...

Hi I am using a Vloockup statement to get the information from 1 file to another file. I have the string below, but it generates the error '1004': ...

Hi, am trying to put a calculation (excel office 2007) that looks at for example A20 and if this is greater than 10,000 then will multiply anything above...