I have a workbook that has multiple worksheets. On one worksheet ('Chart Details') I have the following. Column A represents the date that a ticket was...

Lately, when I use the subtotal function, it does the subtotalling I want, but I don't get the plus or minus signs on the left of the spreadsheet to collapse...

Hi, I'm trying to count the value in one column but only if the criteria in an ajoining column is met. There are loads of columns and rows but 2 columns...

When I view as a page break view, is there a way to get rid of the transparent "Page 1", "Page 2", etc. titles that come up?

I have a mailing label document in word that I want to convert to Excel. The labels are layed out just as it would be from a mail merge but are not in mail...

rTrying to count unique data in a column that contains mixed numbers & text. Have a Sum(If(Frequency(Match) formula but I must have copied it wrong. What is...

E G H 2 y 14 y What is the formula if E2 = y and G2= 14 or less, I want H2 to = y What is the formula if E2 = n and G2= 30 or less, I...

I’m using conditional formatting to change the color of a cell to blue if the date entered in that cell is less than today’s date. The formula works fine...

I just installed a macro and want to have the range of cells that it will update to be defined in the macro. Here is the macro: Sub TRIMALL_alternate() ...

Hey All, Quick questions...hopefully...The formula works great for everything except the '3' and '20', why? It brings back a '0' for both. Am I suppose to...

I forgot my password to an excel worksheet. How can I unprotect to sheet to edit? I have tried all the password I hae used in the past and none work. Please...

Hi, first question so be gentle if this has already asked. I've tried using the search function on Office 2003and on this website (and also Google) but can't...

Hi all, here is the layout of my spreadsheet: a3=apple a4=orange a5=pear b2=red c2=green

Is it possible to copy an entire row to a new workbook based on a specific cell's value? Specifically, if the cell contains a "1" I would like the entire...

I've created a basic formula of =left(c2, 1) and when I hit enter, all I see is the text, not the results. I've checked, and I've got it set for automatic...

Excel XP The formula =CountIf(A1:A50,"80") counts the cells that have a value less than 80. How would I modify this formula to change the criteria to less...

I found the following code snippet that will not allow a user to save a worksheet until cell M2 has been populated: Private Sub Workbook_BeforeSave(ByVal...

I have a spreadsheet with a list of names numbers and emails. I am trying to create that I would be able to type in the last name to a cell and it will...

On Worksheet 1 named Transfer settings I have a table called "transfer_settings". Column A is "Transfer Name" and Column B is "Item #" I would like...

Hello, I am creating a spreadsheet of aggregate spending data. I have several categories, including total, housing, food, apparel, child care, etc. I have a...