1.  Is there a way to programically go through the worksheets and show all
rows where a filter is applied?  I don't want to remove the autofilter.  I
have a macro that needs all rows to show in every worksheet.  I don't know
whether there is a filter applied on any given ...

how do i bring up  teh days of  of a month across columns. whatever todays'
date be, the formula should just check which month we r and should display
the  dates. for eg., when we r in 29/1/2008 the cell should recognise that we
r in month jan and display dates from 31st dec to 3 ...

I am working with excell for tha past 15 years. When ever i make a document,
i used to view about the page set up. Then i used to inincrease the Row space
to adjust the page settings. Yesterday i prepared a document and wanted to
see the page set up or print preview. When i tried ...

Is there a formula to calculate the following by month>
Consultant services 7th Jan 2008 – 30th June 2008   Max 40 hours/week £90 per
hour
Thanks in advance

I am trying to count the number of occurences which occur in 2 columns using:
=SUMPRODUCT(--('CM(Sched)'!AP:AP="BRKD"),--('CM(Sched)'!S:S=0))
In worksheet CM(Sched) column AP is the text "BRKD". In the same worksheet
column S has either a 0 or 1 (numeric).

Is there an array function that will return multiple results found in a list
similar to the way vlookup finds one result ?

I have a issue with using a formula to look at another cell with a formula in
it and pulling the data correctly.
Column "L" has a formula (vlookup) pulling a cell over if it has a
particular symbol "HV".

Is there a way to use the OR function within the SUMIFS function, if
you only want to sum two criteria-values (not consecutive).
Cheers,
Harold

I want to creat a formula that allows data to be automatically entered into a
cell if two conditions match, i.e.
Enter Project Number then it automatically enters the Project name in the
next cell:

Can anyone tell me how I can take the information from four cells in one row
and four columns and stack it into one cell?  I have 300 rows I need to do
this with. You will find a example below:
From: SUPPLIER  CONTACT TELEPHONE    FAX        (COLUMN HEADER)

I upgraded to Office 2007 a few months ago & used the Quick Access Toolbar to
overcome some of the pain of transition. The company Windows 2000 Server has
now been replaced by a Windows Server 2003 & my Quick Access Toolbar has been
reset to the default.

I think it is a setting that was changed, but I can't figure it out.  I used
to be able to press control and apostrophe at the same time to copy the
formula of a cell above the cell that I was in.

I am using this formula =VLOOKUP(C2,UserStatus!A$2:B$492,2,FALSE) to look up
a 7 digit text value in another worksheet within the same workbook. In this
example the value in C2 exists in worksheet UserStatus in column A which is
sorted. I would like to return the value in column ...

I’m looking to run this on the noted row after entries have been made.  Only
problem is – it doesn’t work.
Can you tell me what I’m doing wrong?  I’m just trying to clear a cell if it
has the value “No” in the cell.

I have a spreadsheet I am trying to match like model numbers, however, my
formula is returning #N/A, or if there is a match it returns some number.  I
am using =match(A2,D$2:D$24360).  Thanks for any help
A                 B                                             C            ...