Thanks for the input dave. I am trying to figure out how to take a column of dates and extract a specific range of dates out (ultimatly counting the extracted...

When you are using Data Validation List, Is there any way to assign a macro or formula that will choose preselected entries... for example, I have 10 different...

Is anyone aware of specifications for the random number generator? Namely accuracy, repeatability, etc... Thanks.

Hello: Would you mind to tell me is it possible to find the average on every day with the following data? Date ...

You click on the one you want.

I have a spreadsheet B that referes to spreadsheet A. If I sort spreadsheet A then the references for B don't match. What do I need to add to the formula that...

I am trying to get some values from a different workbook into my sheet. The formula I am using is simple, like this: ='I:\ORKUN\Konya\Istatistik\2'!$D$59 what...

I have 3 columns in XL, A, B and C. A and B contain variables like region code for A and salesman ID for B In C, I have amounts. I would like to add amounts...

When I filter my spread sheets and then try to access the alternatives in the drop down menu the font size takes the text outside of the field of view. How can...

In Excel 97 there are two types of Text Boxes those that are created by the Draw toolbar and those that are created by the Control Box toolbar. One seems to...

The IF function may be used to place a blank value in a cell based on a criteria. Example: =if(iserror(vlookup(a1,table,2,false)),"",vlookup (a1,table,2)) The...

I opened a file. Did not make any changes. When I close the file, I receive a message asking if I want to save changes to the file before closing. I didn't...

I'm trying to get cells to format minutes and seconds ( I always get AM & PM when I format the cell under "time"). I'm trying to add minutes and seconds to get...

Hi, I have a list of cities (more than 2000) stored in a column. What I am trying to do is for a user to enter the first few characters of a city in cell A1...

I am having trouble reproducing the values produced by the Data Analysis tool that calculates a variance-covariance matrix. When I try to calculate one cell...

This is driving me crazy! If I want to "lock" a cell in a formula so that Excel goes back to that same cell when I copy the formula how do I do that? For...

Hello all: I need to rearrange my columns into rows. I've got column headings like this: Heading1 - Heading2 - Heading3 - Heading4 Data1 - Data2 -...

We have a worksheet with macros and every time I try to run them the following error occurs with name of the doc in the brackets. macro error at...

Thank you for your help I used the formula you suggested and I'm getting the #VALUE! error - Any suggestions? -----Original Message----- One way would be...

Have a look in HELP index for INDIRECT "toomis" wrote in message ... hi, was wondering if...