I know I might not get all four of these answered, but any help on any
one of these will help.
1)  When I use the formula to reference the sheet name (tab name), in a
cell   ---  =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)  ---

My formula bar (the case above the sheet which display the content of the
cell) disapeared with no reason... I reinstalled Excel, but didn't came back
! Any idea how to display it again ?

I have a list of phrases in column A of my spreadsheet.  I'm fairly certain
there are duplicate phrases listed and I want to find those without scrolling
thousands of rows.  Is there a function that can help me find duplicate
phrases?

I have a range of vehicles splited by mileage (a row with 10  categories) and
in another sheet I have other categories that I have to sum the vehicles of
the nearest higher mileage range. Ex
Model         10.000       20.000      30.000    40.000    50.000     60.000

I am trying to count the number of times a part number appears in a column of
filtered data.  The part number is repeated because I need to track serial
numbers with it.  I tried using the Countif function but it takes into
accound values that are filtered out.  I sorted my data ...

I want to set up a template of calculations I do in excel. Its like- i open
the Excel template sheet, fill in the data  and the calculations done
automatically. This will save my time. I have seen that people create a set
of sheets with designed formula and calculations. Every ...

The whole formula bar is missing when I open Excel.  How can I make it
reappear?

I am sure this was posted before. What I want is be able to count cell
that have numbers only excluding zeroes and blank cells
--
Ash

This should be simple but the functions that would appear to be the answer
don't work. I have a worksheet name that is contained in column one of
another worksheet row. I want to use that cell content to access the named
worksheet and populate a cell in the same row of the first ...

I have created a VLOOKUP function which looks up a value in a different
Workbook.  
Bases on this returned value I would like to create a VLOOKUP which looks up
a value in the original workbook but a different worksheet.

In an excel spreadsheet I am attempting to count the number of items that
meet two criteria, i.e.,
(Prod #)             (Date Sold)
Column D            Column N

Some way I lock the column and rows . When I click on any cell the number and
letter are high lighted. How do I undo this?

I have used Excel to set up a mark sheet thus:
Name           
    Mark    Grade    Remarks
Mr x    80    1    Distinction

How do I add a column of values to a row of values using an array?
eg: B5+B3,B6+C3,B7+D3,B8+E3,B9+F3,B10+G3

Does this function ignore invisible cells (autofilter) ?
If not, what could be an alternative
--
muchach