I have a spreadsheet that contains columns with text (such as name, job title, hire date, etc.) and several columns with amounts. I want to delete the...

In ColumnG I have the following formula array from row2 all the way down to row100 =IF(ROW(FilteredMonday)-ROW(E2)+1COUNT(F2:F100),"",...

How can I apply a format permanently in a Pivot Chart? For example, adding values to my data graphs and not losing this format upon changing a field to...

We have an excel spreadsheet that is updated by changing select text to red and highlighting in a text cell. So there are only certain strings where the...

Frank, Thanks for replying... we use a report generating tool (access)that gets talks to the database - but the custom reports don't have all...

State : Type1 : Type2 : Type3 : Alaska Arizona Type1 Alaska1 Type1 Arizona1 Type2 Alaska2 Type2 Arizona2 Type3 Alaska3 Type3 Arizona3

I have cells that say if value is equal a certain points will be given if a tie 2 points are given by comparing the score in 2 cells. the problem the games...

I have set macros to be automatically disabled with a notification but the message bar doesn't always come up. Does anyone know why this may happen and how I...

I have cerated a macro button in a spreadsheet, and I would like to know if it is possible to save that button onto a toollbar so that I can use it on any...

In column B I have 1000 time entries with the following format. 9:30AM, 10:30PM. I would like to move the AM or Pm into a new column. I've tried "fixed...

I have an excel sheet in wich I paste everyday new information, replacing the previous day information. There's a clipart that has been pasted over and over,...

I am wanting to lock cell A1 from being able to be populated if both B1 & C1 are both empty. Is this possible?

In a sheet named "Confirmed" I have a spreadsheet which contains the following:- Column F (a list of languages) Column G (a list of languages) Column H (a fee...

On a complete new windows 7 64 bit pc with office 2007, it is running extremly slow when opening documents or inserting normal pictures. When I go to excel,...

The text in some of my cells is turning blue for no apparent reason. The cells can't be changed back to black by reformatting or changing the cell type. It...

Windows XP Pro SP3 Excel 2007 Suppose cells A1:A10 contain integer values. Now suppose cells B1:B10 also contain integer values. I'd like to conditionally...

Hi all, I need some help on the following. Assuming on sheet 1 in a workbook, in column A2 to A30, i have the sheet names listed in each cell, how am i able...

Hello, I ahve a list of names, with middle initials, that I need to break up. For example the names are formatted like the following: Bayer, Daniel E. I...

When saving file, Xcel generates .tmp file xls.~RFe17931.TMP in same folder with the .xls file. Can manually delete, but if I open the file and save again,...

I need help with a VBA for creating NON-REPEATING random numbers between 0-9 in Col B4:B13 and Row C3:L3 Bob