OK I've tried this
data! being the second sheet holding the data
the first array is a condition that I only want customers = "RETAILAC" to be
included

I am using goal seek to solve for a desired IRR ("To Value") by modifying the
initial cash outflow ("By Changing Cell") that is followed by a fixed series
of cash inflows.  The values I input for IRR are whole % (ex. 15.0%, 30.0%,
etc) however, the resulting IRR that is ...

I have a column of different dollar amounts that I would like to have
automatically rounded to 1 decimal with the billion or million after it.
For example: $1,234,555,678.05 automatically converted to $1.5 billion in
another column.

After running a macro that applies a strikethrough to all the cells I have
highlighted, it appears that I lose the "undo" or "back" function, or it
resets it.  Is there any way to disable the resetting of that, or is there
any other way to undo if I run a macro and didn't really ...

I need a way to calculate time left based on how much has been spent to date.
I have an original amount, and a period that the money has been set up to be
spent in, so I need a way to calculate how long we have to spend it based on
what was spent previously.

If I have a date like 1/22/2005, is there a formula that can tell me what day
of the week that date is ?

I am assuming you could only do a VLOOKUP from a worksheet in the same
workbook... is this correct?
(For example, if my lookup array is updated and the values change, do I need
to replace my old lookup table with the new one or can I link it from outside

Hello - hoping someone can help me out.
I have a worksheet with a number of columns and I am attempting to
count the occurances where the value is >=100% in columns headed "% of
Target Achieved" on a row-by-row basis.

I have 5 sets and each set has the following
- Condition 1
- Condition 2
- Amount

I have a list of 500 dates in ColA. Is there an easy way to generate a random
list of 25 dates.
Thank you in advance.

I have a table where the words "closed" or "order" appear. I want to know a
formula that will count how many times each word appears in a column and give
me a figure. Is that possible and how?

I need to subtract two dates in this format to get an elapsed time.
start time
12/15/2005 17:55
end time

Good morning.
I have a simple little query that I want to be available in all
workbooks.  I was told that I should put the macro in a module within
Personal.xls.  I searched my harddrive and I don't have a Personal.xls

I have two worksheets in the same workbook where one sheet have
references to the other to transfer values and text. However, I would
also like to transfer the formats togheter with the values
automatically. How do I do this?

Im working on a super basic order sheet and was hoping to include a
locked row at the top of the sheet. I want to be able to add the data
in a set of cells and when full it add it to the worksheet and then
clear the row ready for a fresh set of data.