I use Excel to capture geologic data most of which is heavily formatted for
visual display and ease of understanding. When I cut and copy data in cells,
sometimes the format is cut or copied as well. I would like Excel to have a
layer on which the format is applied and the data ...

I have a column of text values in which I need to display the ten most
frequently occurring.  I tried setting the AutoFilter and choosing "Top 10",
but it doesn't seem to be doing anything.  I checked into some functions that
I thought might work, like Frequency and Rank, but ...

I have a table in another currency that I want to convert to USD.  Rather
than converting each single cell I want to select the range of cells and get
a new range of cells with the new values.  Appreciate your help!
Max.

Our office is running Office / Excel 2003. When I enter the formula
=CELL("filename") into a cell on my computer and then save the file the cell
displays the filename correctly. But out of all the computers in our office
mine is the only one that this formula works on, we all ...

I am trying to limit the amount of numbers that are in a cell. For example I
have a cell that has this sort of number 1220H123456, and I only want to have
the last six digits in that cell so I can sort in a numerical order. I have
been deleting the first 5 digits manually, but ...

been some time since last time i showed up
anyway...
as u guys know there r serveral calenders type, what i want is functio
that converts a type to another, like convert a crist date to Qamari o

I have completed an excel spreadsheet however I have 5 cells at the top of my
page that I would like to make smaller. When I try to do this it changes the
size of all of the cells on my page.  How do I limit it to just those 5. I
have tried  to highlight them and use the column ...

Search didn't turn up anything, so help would be appreciated.
Simple as the title sounds. I have thousands of words in column A (one
word per cell) and I would like to delete all words 20 letters or
greater.

I have a worksheet that I am trying to use Vlookup on to return specific
info, however vlookup will stop at the first reference it sees and
return that value back instead of the next one which I need.  I am sure
there is a way of telling it to look at the 2nd or third item in the

I would like to do the following :
In sheet 2
A1 = "SE"
B1 = "1"

I would like to have all my data skip a row between itself, without having to
insert a blank row.

I have a worksheet with grouped data that I would like to protect, but allow
the users to group and upgroup the data (the + an - 's).  Any suggestions?

I am trying to create a spreadsheet with calculations for the various
times zones based on GMT.  I use the function TIME(H,M,S).  For
example, to caculate a time in the US EST zone, I entered the formula
E24-TIME(5,0,0), where E24 is 12:00 AM, representing UK time (GMT 0).

I use the Indirect function to summarize data from various worksheets;
If I have a worksheet named "Lucky", I can easily use the indirect
function.  My problem is that I will receive a workbook with a varying
number of worksheets that are named as shipping container numbers.

A brief explanation would be appreciated:
What is the difference between
=sumproduct((A2:A100),(B2:B100))
versus