DOES SOMEONE KNOW WHY ONE  OF MY DROPDOWN LIST OPENS UP INSTED OF DOWN?
I'LIKE TO KNOW IF THERE IS A CHOICE TO OPEN THEM DOWN OR UP. HOW?

Is it possible to move the sheet tabs from the bottom of the worksheet to the
left?

Would like to see a spreadsheet and chart for Utilities in my home.  Also to
see the cost of gas and electricity usage per BTU.

Hi everyone,
I encounter the following problem. All my hyperlinks work except for the
hyperlinks that refer to PDF files. When I click on the hyperlink the
computer wants to start up the application Adobe Acrobat Reader, but within a

Am new to all this but this is what am trying to do
Sheet 1  - list of retail products
Sheet 2   -another list of Retail products but they have children
(materials) these are figures percentages required for the Retail

I used a match() function to find out a specified data in a range, and it
replied a number. Let's say I got 3(column or row). Is there any way to know
how many data in the column 3(or row 3) by using counta() or any other
function, except VBA.

I am trying to have a cell total figures if a cell in a different column
range is met.
Ex.
Column A Sales Month

convert number like(852) to words like(eight hundred fifty two)

How can I filter the values listed in a drop down list based on values
present in another cell? As in....
[List]
Category      Description

Maybe Subsitute is the wrong function.. if it is, let me know of a cleaner
easier way to do this.
Simply, I have a list of 10 Categories, each relating to an individual.  The
issues are all listed in a drop down box in Column B. I want Colmun F to list

I want to do the following:
make
A 2 x
A 2 y

I have some cells that are conditionally formated to fill Blue, Green, or Red.
Is it possible for a macro or a formula to tell me the count of cells that
are Blue, Green, and Red over a given range of cells ?
Thank you in advance.

I am receiving "the formula you typed contains an error" when I try to
execute the following formulas.  Any ideas why these don't work?
=COUNTIF((--(J2:J2000=E8),--(K2:K2000=E9)),M2:M2000)
=MAX(IF((--(J2:J2000=E8),--(K2:K2000=E9)),M2:M2000)))

I thought that by using the SUMPRODUCT function, rather than Array formulas,
the calculation process would be much quicker. However, with over 5000
functions, the calculation is dreadfully slow. Since I am looking up multiple
criteria, is there a benefit of running one type ...

I'm using this formula to determine the top four scores of a competitions
series:
=SUMPRODUCT(LARGE(F2:K2,ROW(INDIRECT("1:4"))))
It works great, but not everyone has done four competitions and since those