Dear group,
I am a total newbie at Excel but have a reason to learn, so in at the
deep end. If I enter a number in say cell 28D and it is the same as the
number already in say Cell D7 then I want the number in D7 to change

I have all the host name in column A but some of the host name is
duplicate. Would you mind to teach me does any formula that can
calculate the number of unique host?
Thanks a lot!

Hi
sheet someone send me, and I was not able to change the heigth of th
colums or rows. Also some cells had "validation" but when I try to g
to validation in the task bar, it is greyed out, and I can't mak

Need help on lesson plan for geometry
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I

Im working on a spreadsheet that has many hyperlinks and I'm foreve
changing there values. This takes twice the amount of time as I have t
mess about in order to stop it from following the link
Is there anyway to make it so that a link is followed ONLY if the Ctr

   Here comes two problems.
  Problem 1: I have a list of strings (say, in the column A1:A100). How can
I find the "mode" (i.e. the string appearing most frequently in the list?
For example, if the list is

I have been playing around with the '&' function, allowing me to mix text
with calculations and cell references.
I have the following at the moment:
="Of the "&TEXT(J954,"£#,0.00")&" made this year, I have managed to save

I am reading a file of decimal numbers into VBA. I can
read them into a variant, or into a DOUBLE. No matter.
When I assign the value to the cells of a worksheet, the
cells are automatically formatted to currency. As a result,

Have scanned the archive and google so now I come to the Oracles...
Problem:
Multi-worksheet excel file created with perl script. This is a report
with graphics, buttons and hyperlinks probably best done in

I cannot figure out how to access the HELP INDEX of subjects

I am having trouble with this excel file. I am converting it to a cvs file
for an import. The problem is that item numbers 760-762 import fine, but
764-767 are skipped on the import. It shows all items in the csv file, but I
must be missing so formatting on the xls file that is ...

in cell E8  I have this formula: =IF(ISBLANK(D8),"",D8*$B$2)
I get the #VALUE! error.
Can someone tell me why and how I can correct it.
I am just trying to say that if D8 is empty don't show anything, if

I have a formula that includes averaging the contents of about 7 or 8 cells.
I don't want the formula to average until data is in all referenced cells. It
wants to average as each cell value is entered. This is example of my
formula: =(B3+ B4+B5+B6+B7+B8+B9+B10)/8   I am new to ...

   I have named a range "Scores" across 3 sheets (i.e.
Sheet1:Sheet3!$A$1:$B$10). How can I find the median of values in "Scores"
in Sheet1 ONLY? I don't know how to provide the target range in the function
MEDIAN().

I am fairly new to Excel and was wanting to know if anyone could recommend a
book that explains just about everythiing you can do in Excel?  Most basic
features to advanced features.
Thanks for you time,