I have 13 excel worksheets in a workbook.  Twelve of them contain various
account numbers and expiration dates, they have different number of columns
used.  I want to create a cumulative sheet that gathers info from 2 columns
from each worksheet (vendor name and expire date), and ...

I'm trying to find a function(or formula) that will return the relative
position of an item selected in a list of items.  For example:  from a
drop-down list, if you choose the 8th item in the list, the function returns
the value "8"; the 3rd item would return the value "3", and ...

I wish to select a name from a data validation list by using the first letter
of the name so I don't have to scroll down to the name, is this possible?

I'm looking for formulas that will give me the first Monday and last Sunday
of a period. For example The First Monday of February 2008 would be February
4 and the last Sunday would be March 2. Add x number of days to the formulas
to give me the first Monday in April 2008 as April ...

I have a spreadsheet that has the date in column A in this form "Friday,
March 06, 2008" and I wanted to be able to pull every row that has a friday
and put into a seperate worksheet.
So ever day that is a friday will put then next 4 cells in the row into a

HELP!!! I have a formula that will tell me how many items are open with a
date in the past what I need now is one that will also tell me how many open
items will be coming up in the next two weeks and one for anything over two
weeks…. Any help would be greatly appreciated.  ...

I have a workbook that has 1000+ rows of data. Users need to be able to
reference information quickly using an ID number, so I set up a cell at the
top of the worksheet where they can enter the ID, and using MATCH (in cell
B2) it finds the row number, then I use an INDIRECT to ...

I applied the DAYS360 function to each month of 2007, and the result is not
30 days for each month. In fact each 31-day month turned out to have an
output of 30 days, each 30-day month has an output of 29, and Feb has an
output of 27. It added up to 353 days for the year using ...

I made an Excel worksheet that contain multiple worksheets. One of
them is a list of products containing multiple columns for different
parts. One of such parts is "LENS" column in which I use data
validation to have users select lenses from a pre-set Lens_List which

I have a long table which looks something like this....
1  4  7  A
1  6  5  D
2  7  4  C

Ok. I need to have a formula which would look at a number of columns
and tell me now many 'consecutive' months someone has been in the top
33% of the numbers in that column to date. IE . . .Ann was in the top
33% in Jan and Feb but not in March so in March I would want the

I'm trying o figure out why this formula isn't working as expected.
I need to check in a column to see if any cells have the number zero
or #NA. If either condition is true, OR should return "True" and then
make the destination cell blank. If neither condition is met then OR

I have Months in Column A (from 1 for Jan to 12 for Dec) and Years in Column B.
I need to find the month corresponding to the earlier date.
For instance if my lowest year is 2004 found in B12 and B24, and A12=2 and
A24=8, the result should be 2

Hello experts,
using Excel '03...
I'm trying to write a formula that checks a range of cells, basically
modifying this formula:

I have a worksheet with 716 rows I need to select every 17th row.  How do I
do that?