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 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...

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...

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...

Using Excel 97, I'm using a very basic spreadsheet to log some files for a business. The reference numbers for the files are all 16 digits long. I've set the...

I have the following macro which appends data from a selected workbook to a masterfile (name always the same) workbook. my problem is after I append the data...

I call this macro from a "Masterfile" workbook. I want to open a trans workbook and append the data from each sheet to the same sheets on the "masterfile"...

ive got the following in my workbook; =MID(CELL("filename",A1),FIND("",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1) is there anyway of getting...

When I cut and paste from another program into an excel spreadsheet I cannot use the CNTRL key to select just the data and the headings on the first page only....

This has been bugging us for ages. We have a solution that works on one page, but not across pages. Does anyone have a "super" vlookup that allows you to...

Here's what I need to do: I have a rectangular array with values for a number of variables (columns) in a number of samples (rows). In another (square)...

Is there a way of finding out who saved a particular file the last time it was saved? Is there a way to find out the history of who saved and when?

Hi all, In my routine job, I have to input data in excel. I want that after I input data in Range "A1", then press Enter button, it will move to right to let...

Hi I would like to put a name in B1(Tony) that triggers a total that i get in G26(43)and have the total in G26 (43) come up in cell L6.Changing the name 8...

Hi Lady Layla I have the same problem as Jeff in PA. I cannot seem to be able to select the data in my Excel file asn then name the cells to create the...

Thanks Charles! This works for all states EXCEPT states that begin with "i"...any suggestions? "Charlie O'Neill" wrote in...

First of all, thanks to everyone who answers our questions--it is a HUGE help. Here is my current dilema: I have a totals bar on Row 1 for a sales...

Hi, trying to delete a empty sheet but after selecting it , the delete sheet button is not active in the edit menu . Why and what should I do? -- XP home ,...

Hi: Setting up charts are perplexing to me. Attempting to plot weights vs dates (lbs along y-axis; dates along x-axis). Every time I get the chart to display...

Cell appears to have nothing in it, but the result of ISBLANK() is FALSE. Why is this.