I am trying to find the Average of the lower 10% of a column of data.  I
cannot figureo out how to do it without including the same values.  Thank you
in advance for any help you can provide

Hi all, TIA.. had a user send me a sheet today, they wish to add 5 more
values to look up. The problem is that the answer that this formula comes
from are set up horizontally, the target cells are vertical so no autofill.
The formula is such:

I want to use the Lookup function to reference cell values, not just
hand-entered values.
For example:
Column A     Column B

In the cells below, shows the formulas with resulting value below
it.......What would cause the #value?
A1    Gretchun
B3    0.65

I need to find the position of the first Numeric sign in a string.
"AA01" = 3
"AB2E3" =3
"2AAFT3" =1

I need the following array formul to only select cell values longer than a
string of 4.  The array works-but I cannot get it to discriminate and only
select values of 5 characters and larger
=IF(ISERROR(LARGE(D6:D14,ROW(INDIRECT("1:4")))),"",LARGE(D6:D14,ROW(INDIRECT("1:4"))))

I have a conditional if statement with 2 conditions.
If condtion 1 is satisfied I would like to display "Yes"
If Conditions 2 is satisfied I would like to display "N/A"
else display "No"

I have multiple pivot tables on 1 Excel worksheet, looking at different data
in different ways.  But in each pivot table, the Page Field name (eg machine
mane) stays the same.  Is there a way to automate entry of 1 field entry into
all of the tables?  My VB knowledge is minimal

Sub makeformulae()
Dim frng As Range
Const sFormula As String = _
"=if(a9="""","""",if(isna(vlookup(a9,råb1,3,false))," & _

I follow a book's example which teaches how to transfer the data (Name &
Sex) from an user form onto a spreadsheet. I follow the procedures
step-by-step but when I clicked the "OK" button which executives the transfer
action, a compile error occurred stating "variables not ...

I wnt to delete a worksheet however the 'delete sheet' is whited out.  also
when I left click on the page name, it is whited out.

Pls tell me the solution.

We have 45 branch locations at our company. Each location is assigned a
merchant number to use when processing credit cards from customers. Our month
end bank statement is around 1000 lines long and lists all of our branches
sales paid for by credit card using their merchant ...

I have my GL Code in Column A, payment date in Column B and amount in Colomn
C and my chart of account in columnt J. I also put a date on the top of my
sheet.
I want to us sumif function to find if the GL code and date is equal to my

I have used the info on this page but I can only get it to apply to the
probability and not the impact as well as I cannot re-use the names for the
risks
Pasty, have a look here,