Anyone know of a way I can do the following. I have a column (B) on my spreadsheet with a given persons name in every other cell. eg. Col A Col B Col...

I have a macro using two Workbooks. I am appending the sheets from the Trans workbook to the same sheets in the Master workbook. I open the Master workbook...

Hi friends, I have two coloumns 'Reason for leaving' and respective 'date of leaving' I want to find out which people left in which month. Like there is a...

Is there a formula I can use that will Rank with changing # of rows. Currently my formula is for example : =RANK(C8,C8:C43) but when I insert rows it throws...

Hi! I don't know how your worksheets are structured, but it sounds as if you are doing some of Excel's work for it! If you have a value in a cell on...

Im trying to run a multivariable regression using excel, and was wondering what the t-stat variable represents. How do I use it to know if that certain...

Hi, I encountered the following problem: If I protect a selection of cells in a worksheet the grouping funciton doesnt work anymo Does any body know the...

I have order received date. I will start the order on the next coming THURDAY always. My delivery date is 9 days from the start. eg. Received date = 5/7/2004....

I have a bunch of hyperlinks in a big spreadsheet that links to some folders on our network. This spreadsheet needs to be both on the network and on the...

How did you create the pivot table? Where is the source data? Merlin wrote: I have come across a problem using pivot tables. After creating the pivot...

Can any body tell me that is it possible to create dependent lists in Combo-boxes ? Thanks --- Message posted from http://www.ExcelForum.com/

Hi (A) does anyone know how to search for the text content of a cell through a column and then return the value/content of the cell of a certain other column...

Is there any way to automatically insert a row? For example, I have a spreadsheet that displays totals in the 40th row for all the data in the columns above it...

I posted this before and, since I am completely mystified, I am posting again: "I have three worksheets of identical layout (and in the same workbook), the...

-- What have I done all my new worksheets now are backward A1 being the very right now! Thanks in advance.........Bob Vance

I have the following macro to sort a range of data: (using Excel 2002) Selection.Sort Key1:=Range("B6"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1,...

Hi! I want to make a kind of countif, to ensures me that no number is repeated in a column. i have that column numbered in sequence, so i would like that once...

I did a months list as it is teached in the book Financial Statements, but I can't change the case of the month title. I mean, the date format is mmmm dd, yyyy...

Is there a way to cut and do a paste special? instead of a copy

The more I use Excel, the more surprises I get! I have a Pivot table based on a 16-column data list, one of the columns being "End Uses," say, office...