diffcult to see the 'auto filter tab' which has been selected as they only
change from black to dark blue.

I want the functions MATCH, INDEX, and AVERAGE to ignore hidden rows, for the
data range specified.  
In addition, worksheet functions containing MATCH will be named, and names
inserted in INDEX.  (I have found that, when specifying data ranges for

I have over 12000 VIN numbers on a worksheet. What I would like to do is find
an equation that would pull all of the VIN numbers that started with a
certain sequence of numbers & Letters -
Ie all VIN numbers that begin with RVS1T3. I've tried using the V-Lookup

I have tried to import a large text file by converting it to .CVS. While this
works to bring in all the records (350K rows) it imports the columns in such
a way that the Text to Edit is to complex needs a lot of manual work. I have
tried the Text Import which does work but this ...

Using a combobox on 1st sheet in a worbook, how can I use it to display data
in a column from sheet 2 in the same workbook?

We have a shift that runs from 19:00 until 07:00 the next day.  How can I get
Excel to calculate the hours without the necessity of adding a date to the
cell.

I have created a pivot table to display salary information for employees
across several departments and job titles.  From the salary column I have
created several data fields: Count of Salaries, Avg Salary, Max Salary, Min
Salary.  I would like to create several addtional fields ...

The formula works fine if the cell contains the Letter B but I would like to
have the same result if I typed B or R . I am not sure if I could nest this
into the formula.

Over a year ago Harlan Grove solved a huge issue for me (see link for
details
http://groups.google.com.au/group/microsoft.public.excel.worksheet.functions/bro
wse_thread/thread/92e93d26ba3aab01/93577d2811f18bbc?lnk=gst&q=clegg&rnum=5&hl=en
#93577d2811f18bbc)
well it's served me very ...

I have a single (large) workbook, with multiple worksheets (all same layout
and format).
These multiple sheets show data being returned from multiple sources. I have
to cross-check another sheet of unique reference numbers to see if they exist

How do I give text codes eg. "LC" or "MC" a numeric or dollars value? I want
the numeric value to be hidden so I am able to insert text codes into cells
then sum a total at the end of a column and/or the bottom of a row that
displays a numeric total. I will have not more than ten ...

I have a workbook with several sheets.  I am trying to determine how many
times "x" appears  - using a specific cell (A5) as my reference in each of
the sheets.  I want to count how many times "x" appears in cell A5 within all
the worksheets and summarize on a summary worksheet.  ...

hello again,
i may have been exagerating my work by having a large spreadsheet that rise
up to 15MB.
I can simplify my effort thru some formula from someone.

I am trying to rank some data but with a condition.
Best seen by example:
Country    Sales    Value    Rank Per Country
AUST.    Dave    25    3

I'm trying to read employee's records, and I have lots of Bobs and others,
but different last names on the following column. The question is: how do I
make it read the next column to match the last name to extract the
information for that row? I can't just use the second column ...