I have an array K1:K5 wherein 35 is one value. When I type:
{=IF(35=K1:K5, ROW(K1:K5), "")}
I neither get any reply nor the ROW number. But when include either MIN/MAX
in front of the IF statement I get the result. Why is it compulsory ? Any

Using Excel 2000, regularly and extensively. Suddenly I've lost the menu bar
in all my spreadsheets and any new ones that I create.
Clicking on a toolbar then <Customise> shows the <Worksheet menu bar> to be
checked. (And if I uncheck it, it simply restores the check) The menu bar ...

I've got a multiboot system with a different Office in each OS.
The main OS has Office 2003.
And I created a workbook with lots of XIRR functions using Excel 2003.
Recently, I've had a need to boot to the system that has Office XP.

I want to be able to select an items from a list I have setup and have
them show in a text box (possibly with the aid of a select button).
Could someone please explain to me how to do this as I have no idea
about Visual Basic and macros don't work?

I use a spreadsheet with macros that lists all the file names of my songs
from my music folder into an excel spreadsheet ( I can post ir if it will
help). My new comupter has Office 2007 and the macro will not work. I do not
know macros well enough to fix it. Does anyone know of ...

I have a list in a file name abc.xls. I have defined the list with a
name say XYZ.
I have another file Summary.xls with a pivot table that I'm using to
give me a summary of that list.

I try to run a VBA code that woks fine in Excel 2003 and it crashes in 2007.
The offending line is
ActiveSheet.ChartObjects("Chart 542").Activate
What could possibly be wrong with that?

I am tracking expenses for different credit card and bank accounts in an
Excel workbook. Everything works just fine except that whenever I enter a 16
digit account number in a cell formatted for Number Category with 0 decimal
places, the last digit changes to "0". The General ...

I am using a Purchase order template, and the order needs to be 2-3 pages
long.  How do I continue the page on to another page and have the ending
total be correct?

Help Pls.
i want to enter data in the first tab, without retyping them in individual
tabs have the automatic sepeared in other tabs.
exp.

I have the following formula on my worksheet:
=ROUNDUP((C3/D3) + (F3/G3) + (I3/J3) + (L3/M3) + (O3/P3) + (R3/S3) +
(U3/V3) + (X3/Y3) + (AA3/AB3) + (AD3/AE3) + (AG3/AH3) + (AJ3/AK3) +
(AM3/AN3) + (AP3/AQ3) + (AS3/AT3) + (AV3/AW3) + (AY3/AZ3) + (BB3/BC3),

When I protect a sheet in Excel 2007 I can't then allow users to edit
objects. Am I doing something wrong? Works fine in 2003

Is it possible to have a function where if you enter the date numerically, eg
'30/3/7'
it returns the DAY & date, eg 'Fri, 30th March 2007' ?
This would obviously work off the computer calander so as to ensure it gets

An "Name Conflict" error message pop-up "Name cannot be the same as a
built-in name". That worksheet was created by Excel 2000 and also could open
on
Excel 2003 without any error message. Change the worksheet file name could

I have a user who when he opens a workbook instead of the single
version of the workbook opening two versions of the workbook are
opened.  These two versions of the same workbook are opened and
displayed, the two workbooks are titled with name:1 and name:2 .  How