I have a work sheet of 5 columns, in the 6 th column I want to look at
the other 5 columns (same row) and return information from the other 5
columns.  There may be blanks in some of the adjacent cells in that
row.  If any of the information that appears in the row more than

Hello, I am trying to get a single column to add up. The column contains a
number for a a type of produce.
Example:
Apples 2,

Do any of you know of a function that will do the same job as the
Frequency array function, but will analyze true/false results instead
of numbers?
I got a column of results in my spreadsheet that contain just logical

It has been a long time - when I set up formulas with just one $ how is that
different..

Someone helped me with this a few years ago and I have since lost his
instructions.  Can someone help me to know what formula I use in
making a chart for starting my seeds.  I would like to be able to have
one cell have the last frost date in it and then be able to type in a

IM MAKING PRICE TAGS AND I WANT TO ROUND UP THE PRICES TO THE NEAREST #
ENDING IN EITHER 39,69, 0R 99
SO IF THE VALUE OF THE CELL WAS 1575 FOR EXAMPLE
I WOULD WANT TO ROUND IT UP TO 1599

I need to sum a range of numbers based on 2 different criteria.  Example:
Col A     Col B
101           5
112         10

I want to create an if function but I want to use more than 7 conditions and
it won't allow me.  If I look in help it suggests using the lookup function
but from what I can see you can't use formulas as the result.  As an example
I want to say if cell A1 is x then use this ...

This is what I'm trying to do:
In column E I have a number ($ - and can be negative or positive numbers)
and in column F I have a percentage.  I want to extract all informational
data on columns A through F in which column E is either greater or less than

I'm trying to pull a 2 digit year from a text sting.  This is how it looks.
I'm trying to extract the 2 digits from the left for the year, then the next
2 digits for the month.  Is there a way of doing this?
     960158963415

I want to create a lits based on a minimum common variable.
I use a program that generates a data table in a specific order.  In
'COL A' are names of clients.  Related data (a percentage) is in 'Col
B' .

I am trying to update a macro.  I know that I can select an individual cell
using a variable by using the Cells property.  I simply insert the variable
into the parameter as an index number for a row or column.  However, if I
want to work with a range of cells, there is no way to ...

I am searching for a formula that will provide a quantity for materials based
on sum of lengths.  There will need to be a parameter giving the length of
the base material.  For example,  if pipe comes in a twenty foot length and I
am cutting this into a 9 foot, 12 foot, and 6 ...

Repost for clarification and hopefully a quicker answer....
Sorry for the repost I tried to calrify yesterday but probably better to
start all over
My data is in A1:G12 I need a formula that will find the max of B2:G2, then

Referring to the post in General Question
Does anyone know how to remove the top & bottom 10 % from a list? such as
There is a list of values under column A, the number of values is not
defined, it can be as small as 10 values, and it can be as large as 6000