I have a spreadsheet with various test results. I ask the user to copy
all (only option) the records once a day and paste into these into
spreadsheet from application. What I would like is for when this
occurs a macro that deletes all data unless it is new into another

I have an Excel spreadsheet that gets up to date values from an external
source using RTD.  At the end of the day, I save the sheet. If I open the
sheet and my external source is not available, I have a choice to update, or
not update the sheet.  Even if I choose, DO NOT UPDATE, ...

I've got a payroll dump where everything is in caps (eg First Name and
Surname) - about 2000 rows.
To make it easier on the eye I'd like to add new columns so each text cell
is shown as Initial Caps

I am working with a formula in which the value of one of the inputcells
changes dynamically (stock quote). What can i do to automatically put the
changing outcome of the formula in a series in a colum?
Can anybody help me out ?

Looking to get a formula for the following scenerio:
if H1 is greater than I1, then J1 is "Yes" and of not J1 is "No"

Can anyone help me develop a worksheet function, set of functions, or macros
to get this going?
I need to calculate the Total number of times
a Part# is sold, filtered by the number of times it was sold by an

I can't see the activex controls embedded in a worksheet - they're present
because I can click on them but they don't show on the sheet. How do I make
them visible?

I would like to do a conditional format - like if the total are higher than
100 it should flash in red.

Pivot table short cut keys and more options required very urgently

I have a spreadsheet that in simplified form looke like this:
A    B    C    D    E    F    G    H     I     J      K     L   M        N
21    0.3    34000        101 102 103 106  209 304
21    0.5    40000        105 107 203 206  3

I like the COUNTIF function but want to include the ability to expand
the "match" criteria to include data in other columns.  Possible?

How do i change the string of number into text. (Not just the format)
When i key in "US$1,234.00", another cell will appear "United States Dollars
One Thousand Two Hundred Thirty Four only."

can the border of the cursor cell 'input cell' be changed so that it is more
pronounced?

I have did some read up about having '--' in writing up the SUM PRODUCT
function on some websites. But still trying to figure out the reason behind
having '--' in our SUMPRODUCT function. For example,
=SUMPRODUCT(--(PLList=B15),(ShipmKList),--(CountryList=$C$2))

I'm trying to create a single formula that evaluates to the Shannon
diversity index (SDI) on a single array.  An explanation of SDI can be
found on http://en.wikipedia.org/wiki/Diversity_index.
SDI = -E { p(i)*log(p(i)) }