In Excel'97, a complex spread sheet computes y = f(u, v) where y is the
answer and u and v  are variables.  There are other variables as well,
so really
y = f( u, v, x, w) , but lets assume x and w are constant.

I have a data in columns, I want data to be shown only if there is
data in that row if no data then leave it blank (here is what I am
asking for)
Stock trade   Gain/Loss     Gain/Loss all trades

I have this formula an if there is no data them i get div/0 how to fix
it so if no data then blank
=AVERAGE(IF(N6:N100=0,"",N6:N100))

Here's my data:
  A             B               C              D                E          
F         G
George     Jones          Pro           Deb           Smith       Am      153

Trying to create a work sheet that will seach through entries for the
greatest value

I have Column b with Name in one row and number in 2nd row want to move all
numbers to Column a and leave name in Column b without having to move each
one seperate. 1500 records.

I created in Excel a macro designed to send specific mails via Outlook.
Because  an Outlook dialog box asked me all the time whether I authorize the
transmission or not, I created a certificate using  MS Office "SelfCert".
So far so good. My macro is signed.

I'm looking for a way to search a range in a list and pick the top 10
from that list. Once this has been done, I then need to copy the data
to another sheet elsewhere
For example, I have a sheet called "MainList" (http://

I have a master spreadsheet which I'll call MASTER1 which has a header
row, nine rows total.  In rows 2 - 9, column C has the name of a NY
city.  Column C has already been sorted.  As an example, cell C2 has
the value of "Albany", as well as cells C3 and C4.  Cells C5 - C9 have

I am using Excel 2003.  Not sure what happens, but when in Excel and move to
another cell, all cells in between are highlighted.  I am not holding down
the left mouse button etc. so that the cells are highlighted.  Once this
occurs, it affects every program in my computer.  ...

HYCH
Is there a way of disabling the Tools Option on the menu bar with VBA?
Steve

You gotta admit, Excel 2002 10.2614.2625's Formula Auditing is the
greatest thing since, well, the reintroduction of unsliced bread.
However, I have workbooks with dozens of sheets.
For references on other sheets, all Tools / Formula Auditing does is

Iam working on a project with excel 2003, and I am trying to assign a vale
you to yes "yes = 1" and "no = 2" and then good back and add up the yes and
no.
help I have look for about 3hr and cant work it out?

Hello all,  I have a spreadsheet listling multiple products I am testing.
Each product may have multiple steps (rows). At the top of each product, I
have the owners name in a owners name column. I want to be able to filter by
owner, so I only show one owners product at a time. ...

I am relatively new to Excel and have just started using Excel 2007.  The
color used when highlighting a cell is a very faint grey and hard to see.  I
was wondering if there was a way to change it