I am having difficulty applying sub-total to a filtered worksheet. My worksheet has 11 columns (6 shown in the example below). At the bottom of the...

How is it possible, or what format do I need to be able to subract time across days. Example, would be if I'm trying to see how long it took to get a...

Hi I have a formula =MOD(T11-R11,1)*24 Where T11 is 22:43 and R11 is 22:34 The difference of these time values is 9 minutes or .15. Currently I am...

I would like to create a formula or macro that will take a number that always comes from the same cell but then pastes that information in the first blank...

Hi, I'm struggling here. Here is my Layout: Period 1 Period 2 Period 3 ... ...

Hi, I have 10 working files in an active window. There is no Save All button under the file menu. May I know if I can save all the files at one click...

I would like to count a range if all the numbers in that range meet a stated criteria. For example I have 50 columns (so 50 ranges) and I want to see how...

I have a workbook that contains 100 worksheets. On each work sheet I have the following code (see below) that runs and when a particular person is selected...

How do I switch off that autocomplete or autoformat or whatever the name of that feature, which transform a decimal number like 12.42 into marcian-looking...

I the same sheet of the same workbook, some of my cells are displaying the value (for calculated values), whilst others are displaying the formula....

I have a excel book where I link on-line quotes from internet. HOW DO I SET UP AN ALERT TO ACTIVATE A SOUND WHEN THE CONTENT IN A CERTAIN CELL REACHES A...

Hi, I have 26 different lists on one sheet. On a second sheet, I have a cell that is displaying these lists depending on a value that the user chooses....

Excel 2007 I have an Excel file that is I would like to change the password on this file, but it will not let me. How do I change this file so it is not...

I imported a table from Access (2003) into Excel (2003). A column that contains numbers do not add correctly using the SUM function; however, it adds...

Pivot table contains the following columns: Item No. / Ord Date / Ord No. / Cust No. / Cust Name / Ord Status / Ord Qty. The sorting is on Item No., Ord Date...

I have the next problem while working with big report with macroses. The first time report is opened and executed with special file it with Excel for Mac 2004....

I'm looking to create an excel file with drop down menus. I'd like to have a category. Click on the "+" symbol and the category opens up and shows all of...

I want to fill across a row using the pattern: ='Q:\DATA\Sheet2'!$A1 ='Q:\DATA\Sheet2'!$B1 ='Q:\DATA\Sheet2'!$C1 etc. I don't have access to this Q drive,...

I am regularly inputting words in French and their English translations Column A contains my expanding list of French words Column B contains their English...

Do we have sorting for the rows same as for columns. If suppose I want to hide the columns containing blank cells in a perticular row.can I do it or can I...