I have used
=IF(Original!C33="","",Original!C33)
to avoid pulling 0 numbers across but I have come across a secondary
problem where

I have a formula in a spreadsheet
=Original!C33
there is nothing in Original!C33 but a 0 is being returned. How do I
get rid of these anomolies?

What formula would I use to find the lowest value in a selection of
data i.e. B49:E52.
Much Appreciated
Brian

Have been using Excel 97 for some time now, but have never run across this
before.
Still consider myself a new user, though.
In the middle of my workbook, about 1/2 way down, Excel now has a dashed

I got have my recorded macro setup the way I want, however when I want to run
it on a new update spreadsheet I cant. Is there a way to run this recorded
macro, without having to re-create it all over again?

On Sheet 2 I have ranges in column C, column E and column G all of different
lengths and all changing in size as data is added, but all starting in row
3.
What I would like to do is to copy the range from Sheet 2, column C to

I have several cells that refer to other cells ie: = Sheet1!$b$21
they worked fine until a couple days ago. Now they all have # in them
instead of the number (general) in Sheet1!$B$21
The formula shows ok and if i put the curser on the cell it shows the number

3*2    3*3
3*2    3*4
3*4    3*4
3*2    3*2

Is there a limit to how many substitute functions I can have in one
formula? It does not seem to let me have more than 8.   If there is a
limit, is there a work around?
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(BM2,"Oscar

I have a spreadsheet that tracks the number of screens completed in doctors
offices each month. What I would like to do is set the CF in Excel07 so that
an arrow appears next to the number showing whether the screens for that
month increased, stayed the same, or decreased.

I am new excel 2003 and I'm learning at my own pace.  I have recorded several
macros.  As a new excel user I am having not having much success opening up
and deleting some of the macros that I have created and in need of some step
by step instruction.  Might anybody have any ...

Can anyone tell me of a good user friendly software program that lets me
import data from a PDF file into Excel. I want the ability to pick and
choose certain fields into Excel. I'm trying to take a PDF file from one of
my ADP reports(Labor Distribution) and bring in certain ...

At home I have Office 2007 and I have some  questions on being able to
run a multiple regression model with Excel 2007.
- In my work copy of Excel 2003 I woudl typically go to Tools and then
Data Analysis to be able to run a statistical analysis.  If data

The problem deals with using a simple formula to determine the lookup value
in vlookup, if the formula (result) involves a decimal.
In EXCEL 2007, I have a table with row numbers and labels. I have another
table with row numbers that are a consistent increment higher than the ...

I have a report where I want to use conditional formatting on the two
far right-hand columns.
Applying conditional formatting to right-hand column 1 (RHC1) which
consists of percentages is easy. If the value in any cell in this