I think this is doable and easy, but i can not figure it out for the life of
me.
I have a macro that clears on the information from the screen.  Can you have
something in the macro, that will prompt the user to ask a question, such as,

When applied to the example data below, this formula will retrieve th
data in columns B and C when the value in column A equals 3.
*array entered*
=IF(ISERROR(INDEX(Sheet1!$A$1:$C$6,SMALL(IF(Sheet1!$A$1:$A$6=3,ROW(Sheet1!$A$1:$A$6)),ROW(1:1)),

i am dealing with 30000 line items of data.  i would like to populate various
worksheets based on updated data on the "DATA" sheet.  Example:  Data sheet
has data for 30 different product lines.  i would like to select product A
and any related data to product A and move it on a ...

Attempted to embed a sumif into a sumif.  Formula
=sumif(Gift,1,sumif(PerPay,"<>0",Children)) returns message "The formula you
types contains an error."
Need to sum the range "Children" based on criteria in both the "Gift" and

I have a cell on one sheet that sums up a col. [=sum(a11:a25)].
now I want to copy that total to a data sheet, but it keeps coming up
as #value.
How do I change the  formula from one sheet to a value on another

it's been so long since I've used excel I'm having problems rememberin
how to use the functions.
I need to know how to set up a worksheet so that if I enter any numbe
in one cell it will automatically mulitiply that number by 15 and plac

I am trying to do a lab report and I cannot figure out how to set up a
frequency report on my project.  I figured out my other question about the
conversions.  Now I'm onto this part of the project.

I need to create an equation.
If (roundup(AE104*2,-3)>=300000) then =300000 or if  
(roundup(AE104*2,-3)<300000) then =roundup(AE104*2,-3)
Basically:

I have a spreadsheet with approx. 10000 rows. And i would like to select and
copy the yellow rows and paste them to another sheet. Or delete cells which
are not yellow.
I think that i can do it by putting an if statement in each row and filter

I have a master sheet that has all of my current jobs that are finished as
well as the ones that are not complete. I have a column that states finished
that I insert a "x" in when complete. I am looking to use something like a
vlookup or hlookup of something that will allow me to ...

I want to enter information (e.g. RM1) and the second column would
automatically input information that would be equivalent to it (e.g. Room 1).
Example:
 Column 1: RM1

I have over a 1000 general ledger account number from which I need to select
a sample of 60 unique numbers.  The only option my co-workers and I can find
in Excel uses replacement and we end up with duplicates.  Does anyone know a
solution?

Do you know what a plus sign in front of an if statement means?  I have a
spreadsheet that has the following equation in it and it seems to evaluate
the same regardless of whether it's =+IF or =IF ????????
=+IF(J24-(Q24+M24+L24+R24)>0,J24-(Q24+M24+L24+R24),0)

I use Excell 2002.  The function EDATE appears to be available.  But it does
not work.

I have a spreadsheet that is linked to another spreadsheet using the
following:
=IF(ISBLANK('http://uknetfs/BenefitPlanReview/[Benefit_Plan_Review_Log.csv]Benefit_Plan_Review_Log'!$N2),"",'http://uknetfs/BenefitPlanReview/[Benefit_Plan_Review_Log.csv]Benefit_Plan_Review_Log'!$N2)