I am trying to define a name in a sheet (the name of the sheet will change
each, and I need function to insert into a macro, which will re-define this
named ranged each time a system generates a new file).
For the named range, I am using

I have a large Excel 2007 table of items showing budgets, actuals, variances
and % variances. How do I highlight row text and background coloring whenever
the row % variance cell is less that -50% (ie, the row is more than 50% over
budget).

I have a range I'm defining in the name manager, and when I enter the formula
OFFSET(a1,0,0,count(a:a),10)
then shft-tab/tab to get the blinking highlight of what it's defining, it's
clearly seeing the right range.

I have a worksheet with three columns and thousands of rows.  I am trying to
find 250 duplicates within 46000 rows. Seems like a piece of cake until you
factor in an ID number that makes every row unique.  I need to make a list of
all the duplicates.  Here is an example of the ...

I have data in a single row array.  The data is not contiguous such that
there are holes in the data.  Several cells may be blank in the first few
cells, in the middle cells, or in the last cells.  I need to identify which
cell is the one where the data begins.  In addition, I ...

My new Excel 2007 worksheets are opening with numerical lables on the rows
and columns.  I have not been able to figure out how to change the column
lables to alpha characters.  Any one able to help?
Thanks.

We use an Excel spreadsheet to calculate drug doses for our veterinary
surgical practice.  Is there a way to format the cell to round up or down?  I
have tried using the round function but it does not work the way we need it
to.  Basically, if the number after the decimal point ...

I am getting #N/A  as a result  of these VLOOKUP's  
=VLOOKUP(A5,'Line Audit FOLLOW UP'!$C$256:$AP$1500,24,FALSE)
=VLOOKUP(A5,'Line Audit FOLLOW UP'!$C$256:$AP$1500,25,FALSE)
=VLOOKUP(A5,'Line Audit FOLLOW UP'!$C$256:$AP$1500,26,FALSE)  ...etc

While day trading I'm required to keep a time log when each trade has been
executed.

I am needing to create a formula that will give me .......
If (cell number) is greater then 48 then what is the difference.  If it is
48 or less then difference shouldn state 0.
HELP Please!

how do i doa formula that will count or sum a bunch of numbers that are
between a particular range. i.e. >100 but < 200 ?

if column A "text" and column A "more text" and column B date > 5/18 and less
than 5/22  (***date is the current week) then sum number in column C.
basically looking for: based what's in column A, the dates in column B
should be the current week, then add whats in column C

I am looking for a formula that will delete duplicate records from different
worksheets.
It can consolidate all of the data onto one sheet then search for duplicates
to delete them.

I don't know if this is possible. Can someone tell me if Excel allows you to
use the SUM function to add those values that have been color coded, i.e: add
up only those cells containing values in red, or blue, or green?
So far I haven't been able to find this. I have the feeling ...

I have the following function in an Excel 2007 workbook and it works well.
=COUNTIFS(Articles!E3:E55,"Quality of
Products",Articles!M3:M55,">0")+COUNTIFS(Articles!F3:F55,"Quality of
Products",Articles!M3:M55,">0")