Hi all. Hope you can help.
I have a sheet which has conditional formatting which sets all
zero values to white fonts.
However, although the sheet effectively shows a blank cell in all

I need to insert an Excel worksheet in the PACS (Picture Archiving and
Communications System) in our medical imaging department. Our
PACS only accept JPEG or TIFF or DICOM format. Currently, we convert the
Excel sheet to PDF and then JPEG and then insert it in the PACS.

I'm attaching the exel file I'm having problems with.
I'm trying to write a forumula that will list the top 5 "TotalCharges"
in the "reservations" worksheet, and the corrisponding "CustNo".  Yo
can see what I attempted on the "totalcharges" worksheet.  

Trying to get value to return from a table where the row and column reference
intersect and to bring that value back to the previous worksheet.
EG table looks a litle like this
         A   B    C   D   E   F

Is it possible to link the information you type in one Worksheet to another
worksheet.
Have individual worksheets for employees sick time, vacation time, etc. Is
there a way to create a summary sheet of all employees so that when a new

I have a very large price list in a spreadsheet, what i like to do is export
certain information from those spreadsheet into another spreadsheet ie:
Name  Description price ?
what i tried to use was a lookup function but it went really bad it needs to

Have any1 solution for video timecode cells formating?
Style as follows:
HH:MM:SS:FF (FF  frames 25f per sec)
01:48:10:24

How do I change the range of data in a specific matrix, upon which other
lookup formulas are referring to.  I keep getting "value" and "ref" errors.

How to get an amortization schedule knowing principle, APR, and payment
amount?  I want to know how long it will take to pay off using different pmt
amoynts.

Does anyone know how to add a button if clicked can automatically add
row or column along with formula? By having the button will allow
someone to add as many row as possible without being through hassle to
copy all formula everytime new row or column is added.  thanks much

At work I am constantly using VLOOKUP to compare one long list to other lists
to determine common elements or differences between the lists.  I need a
simple function that will let me input two lists (named ranges?) and an
argument to output items in the first list that are ...

I have a small problem with a sheet I have created. I use the followin
function to display a customer name and address.
=IF($B$6<>"",(VLOOKUP($B$6,Customer_File,2,FALSE)),"") in cell B8
=IF($B$6<>"",(VLOOKUP($B$6,Customer_File,3,FALSE)),"") in cell B9

i am having two worksheets
worksheet1
it is having some employee details like
empid     name    address  salary............

I would like to put a formula in the worksheet tab to instrusted it to pull
its name from another tab.i.e. ='Snap Shot' A2  Have it pull its name from
the snap shot tab cell A2

i have a excel sheel with different print pages separeted by print area
like
page1
page2