Hi, I'd like to be able to refer to a Named Range on another workbook, let's call it Employees.xls, from a second workbook, something like...

I had down loaded the array functions by Alan Beban. Have them installed as addins. When I run the function I get only one line. Also it will not allow wild...

hi, I have got one Excel sheet which is password protected , some of the other users know this password, what i want to do is allow these users to change some...

I am using Excel 2000 and I need to round up number to the nearest quarter. For example if I enter 1.15 I want excel to round it up to 1.25, if entered 1.37 to...

Does anyone have an alternative to LOOKUP(LU_Value;LU_Vector;Range) if the lookup vector contains formulas? Thanks! /A

I am using =min(a1:a10,b1:b10)to return the min number in two fields, however i want the cell to remain blank or return "0" if another cell is blank or zero....

I use the Excel keyboard shortcut constantly. Yesterday, the Ctrl+Shift+arrow up/down stopped working. It does not select the data to the bottom/top of the...

I want to repeat a cell in a formula for multiple cells

Is there a way to add a time zone to an auto-format? For instance, I have a sheet that enters the current time into a particular cell when a command button is...

I'm counting the number of occurences in a column: COUNTIF (a1:a20,"Ontario") the answer is 8 (8 of the 20 entries in the column say "Ontario") But I want to...

if i have dates ...suppose feb 14 with the 3 on one worksheet and feb 14,feb 15 with values on a different worksheet. i just want sum for each date

I would like to select a range of cells and make a formula so that when I input a particular number in them, the next column will fill in a name. I have a...

I sure this is an easy one and has been posted may times, but could not find a post that matches, or even what to call this other than autofill. If I was to...

When using the lookup function in Excel 2003, it would be extremely helpful to have an error appear if the looked up item does not appear in the list. Example:...

Hello all, I have a problem and I hope you can help me solve it. I am creating an excel spread sheet to collect data from other sheets and compare them. I...

Could you please advise me how to create a "check mark" in any cell? Thank you. -- Shooter

How do I build a count calculation for column entries where duplicate items are only counted once

I get error message "there are too many records to vcomplete this operation" when refreshing certain Pivot tables in a worksheet. Other Pivot tables in the...

I was hoping to be able to do a MOD-10 check on a credit card number in Excel 2000. If it can't be done in Excel itself, is there a macro that can be done in...

Is there a function that will put a page number in a cell? There does not seem to be problem including the page number in the header/footer so how do I show...