is it possible to use the index match method with multiple sheets? And how might it be done? I've tried a couple of different things. My Data is quite...

Alex, =INT(A1/10)+1 More generally, =INT(A1/NumOfLevels)+1 HTH, Bernie

Thanks Kevin. I'm going to email the file to you. It's a tough one..... Lynn -----Original Message----- Hi Lynn, You have to do a bit of detective...

I have no knowledge of formulas or functions. I have 2 cells with one number in each. In the 3rd cell I would like to choose the greater of the first 2...

Hi It seems you have some formulas in cells C84, E84 and G84, which sometimes return #DIV/0 Use in those formulas error checking,...

I am trying to use the insert function in developing a VBA application for Excel and I noticed the second parameter to the Insert function in the new Office...

I need to add a trailing comma to a number. I have a column with a few thousands rows in it, and I need to add a comma to each number. I need to use this...

I cannot get the VLOOKUP function to work for the life of me. I have never used it before, but I have a perfect application for its function. I have one...

In referencing cell simply using = , is there a way to get the color format to transfer over to the new cell? It seems like a simple request, but I can't...

Is it possible to change worksheet orientation? Standard is that we have columns: A, B, C, D... and rows 1, 2, 3, 4, 5... Is there any trick to have rows: A,...

Hi Anders, Thanks for the response. Yes, of course, R, not M--that was a typo. Glad you caught that. empty buffer columns... as far as I know the...

Hi, is it possible to count the whole worksheet by how many instances of a all numbers occur?

I want to select and delete all the rows beginning with a row containing a cell with certain text and ending with a row containing a cell with other specified...

Why can't users change the alternate starup file location in excel 2002? If they change it as soon as they open it back up it goes back to the original. For...

I am creating a work sheet and don't remember how to insert a section break, I belive that is what it's called. I want to created two or three different...

AH Ryan, If only it was that easy! That type of ease is found only with real math programs like Mathematica. In a spreadsheet you have to do some work. To fins...

How do I increase the maximum number of characters allowed in a cell. I need to include comments that seem to exceed what is allowed. It will only "autosize"...

I'm trying to count a column with some kind of criteria. Count if cell contains EL or HC or MM etc. Can it be done with the countif functions? Appreciate any...

Hello, I use Excel 2002 and I will appreciate having a detailed procedure of creating a new user defined function and storing it in the personal.xls...

I work for a very large company. We have multiple offices in many states. I need to create a series of userforms so the user can update employee information in...