Hello experts,
I have a list that I'm using as part of a validation function.  The
list is in the same spreadsheet; I just hide it off to the side.
The list works well and the user can select from the list (drop down)

I would like to use the SMALL() function to look through a range (A2:A243)
to pick out a certain value.
The problem is that the values in that range are from 1 to 10 with each
value repeating multiple times (1, 2, 3.1, 3.2, 3.3, 4.1, 4.2, 4.3, 5, 6.1,

I am close to an answer but lack of knowledge is frustrating me. The event
below is fired by a prompt
(suggested by a formula) being overwritten by a user. The prompt is half
grey by default, but

I have a huge dataset, 10,000+ rows many times over, of date + hour.
(i.e. 7/1/2004 16:00)
The point of my data is that there is not a value for each consecutive date
+ time, some are missing. I need to format my data (for a statistical

I am trying to convert a flow chart into series of questions. Right now I
have a flow chart that asks a yes/no question. I would like to set up
something where it asks the first question and then if they answer yes, it
gives them the next question if no, then it asks a different ...

I have a pivot table set up and when I click on a cell to drill down, it
pulls up all the data but the sort makes no sense!  Does anyone know what the
sort criteria is and how to change it??

I recently posted a question about error bars.  Jon Peltier help a lot.  Now
that i know how to create the error bars, i was wondering if it is possible
to place the value attached to the error bar on the chart itself, above the
bar.  If anyone can help i would appricate it.

I am trying to create an order form that will generate an order number based
on the date the order is written. I would like to have the number shown
without the slashes (/).  Example: If the order is written on 2/23/07, I
would like the order number to be

I'm importing a report that generates colored cells that represent different
values. I need to change those colored squares to numbers to work with the
values.
Is there such a formula?

OK. I am using this command to hide/unhide several rows of a sheet that have
nonessential information.  As my workbook has many sheets, I would like to be
able to Hide/Unhide rows on ALL the sheets. I know I can copy the command for
each sheet, but there must be an easier way.  ...

I am still new to excel and I am working on a project.  I have been
looking all over the net to try and find out what the  $ in a function
means.  For example, =PPMT($E$6/12,$B$15,$E$8,-$B$6) and =IPMT($E
$6/12,$B$15,$E$8,-$B$6).  Please someone help!!

I have IF formulas referencing information that is populated monthly. I've
copied the formula's down for the next several years, but won't need those
formula's to calculate until the corresponding month of data is input. So my
IF formula's are yielding either TRUE or FALSE ...

Changing the format to number didn't make any difference.

I have a sample file that contains just 1 formula:
=IF(COUNT(B2:S2)=0,"",IF(COUNT(B2:S2)<5,AVERAGE(B2:S2),AVERAGE(SMALL(S2:INDEX(B2:S2,LARGE(IF(B2:S2<>"",COLUMN(B2:S2)-1),5)),{1,2,3,4}))))
This formula averages the 4 lowest values from the last 5 values in the
range, or, if there ...

I have a problem with selecting cells.
The selection allways goes from column A to M.
The number of rows starts allways from A 11, to the LAST CELL in column A
which contains a number