DataValidationAllowList, which may be referred to by a named range, a range of cells, or a list enetered in the window, each choice separated by...

how can I change the size of each cell consistency? I mean width and height of each cell. Thanks!!

Im pretty sure the answer is yes, but I have heard of some people having problems with cell formatting options (font, color, etc.) when either upgrading from...

Is it possible to base a criterion for a function like Countif on the fill colour of the cells in the specified range?

Hello, I have a simple question, I think. I would like to calculate the interest that a bank gives me on a deposit. Each month they give me the correspondent...

How do I get an Excel Function to place a NULL value in a cell vs. a blank or space. An example: Cell A1 contains the number 11, when I enter the formula...

How do you make SQL statement calls to a SQL Server database from within Excel? Can they be made as part of a cell formula and recalculated periodically?

When i copy one worksheet to another Workbook then message apper "Not Enough Memory" but in my System have enough memory (128 MB RAM, 40 GB HDD , Cele 1.2 Ghz...

How do you print your worksheet and show your formulas so you can analyze the formulas on paper?

I'm using excel 2000 and have added data validation to a number of cells, the "valid data" being a list - i have ticked the relevant "display in cell dropdown"...

I have a problem with som "enourmous" formula when I would like to calculate a weighted moving average. Under is what I do today. With a moving average of...

Hi I would use a pivot table but there are other restrictions that apply. 1. Some columns are merged and the pivot table doesn't work. 2. I need to do further...

Hi All, I`m looking for a function in excel that will return todays date in a ‘yyyymmdd’ format when a worksheet opens. This date would be populated on...

I would like to know if there is a way to take a worksheet tab and tile pieces of the spreadsheet down the sheet instead of across to get the whole worksheet...

I have two worksheets (W/S1 & W/S2) that work together for different information. What I'm trying to accomplish is create a formula that will take the value...

When I open my cube report, it automatically starts connecting to the Olap cube and refreshing the report. It used to not do this, but I accidentally checked...

I need to find a minimum value, but not including any values of zero.

Hi I am trying to get the vlookup function in excel to work. unfortunately I am using a german excel 2002 which doesn't now the name "vlookup". Does any body...

Can anyone advise? Is there a simple way of transfering a 13sheet workbook direct to a Palm Tungsten E hand held. It appears that the hand held only recognises...

Can anyone help with the issue outlined in the email below? I tried the recommendation of Pivot Grouping - but that doesn't appear to work? Would greatly...