i got this array formula... where e4:e86, aq6 and aq5 are dates ={COUNT(IF(($E$4:$E$86=AQ6)*($E$4:$E$86=AQ5),$E$4:$E$86))} i understand it... but how...

I am having problems using OLAP cubes. I have successfully created a cube and pivot tables using this cube. I refresh the first pivot table and it works ok....

When i leave Excel on, and my monitor goes to a screen saver mode, Excel shrinks to a window that shows only the top tool bar. This causes me to have to click...

I'm using the advanced filter and would like to be able to see the set of rows that are hidden after I've viewed the set of rows that the filter shows. Some of...

I have Office 2000 on my computer. I have just registered for a course in Excel, but learned that I need Excel 2002. Excel 2002 is not available at retail....

I am creating a template (several templates actually). In each of these templates it would be helpful ot insert the date that the .xls file is created from...

Can someone please tell me how to rename a cell column ie in excell they are a, b, c, d etc and I want to to rename them so that it frees up line "1". Is...

IS it possible to scan a list and if criteria is met insert a row that contains a simple summation? Ex: Our company runs a manhour report and once...

i have an excel spreadsheet that contains about 2000 rows of data. one of the columns is a 17 digit number that acts like a label, (I cannot format the...

A friend of mine using Office 2003 has rung me with this quiery: His worksheet which was imported from an older version of Office contains an image in the...

hi i have an excel sheet in which the cell A1 is getting data from a DDE server. So this cell has a formula i.e. =edemo!tik!id0. I want to access this live...

You have to format the cells. On the format toolbar are two buttons, one to increase and one to decrease the number of zeros displayed in a cell. If they are...

Hi, I am just new to this forum and am in great need of help :-) I am trying to create an external reference to an excel file called... 'OS orders...

Hi, I didn't know whether to post this here or where in the Office section. Basically, this happens in Excel most commonly but it other applications aswell....

Thanx Andy... Can I search a list of employees and color code them per thier name? (fill color) Nick

Hi! I'm creating a spreadsheet that will take my daily income and expenditure balance and post it to a specific cell against the date for that day in the...

I get the error messagec excel.exe has generated errors and will close when i open certain workbooks they have a macro, but i get it even if i disable them,...

I'm trying to create a bar chart from 3 different data columns. What I'm looking to do is use the 1st column as one whole bar, but to put columns 2 and 3 into...

hello all, any help with this would be greatly appreciated... there's a cell were a user is asked to input data, and a command button marked 'submit'. There...

Thanks everone, it finally works!!!! Great Another question about this: If I want to have more then one macro run when the file opens do I just add more at...