Hi, I'm trying to calculate how far from the bottom (last entry) of a table
other last column entries are.
LOOKUP is locating the last value in any given column for me, and by then
applying MATCH, which generates a ROW number, I take this away from the last

Added text to a cell, went to Format > Cells > Font > Color to change the
font color and Excel shutdown. All text that I had added was lost! This has
happened on 3 separate occasions.
Is there a fix for this?

I'm not entirely familiar with vlookup so please bear with me.
I'm interested in searching approximately 35 worksheets in a workbook for a
specific string. Once I find the right string, I want to search that page for
2 or 3 specific elements. Once I find all of those elements I ...

I have a worksheet where I have calculated many cell values from formulas
based on other cells. However, I want to export these calculations to another
worksheet so that I can compare them with other calculations. When I try to
export this information it all becomes error symbols ...

I have a spreadsheet with several hundred 17 digit alphanumeric numbers in a
column. Is there a way that the spreadsheet can find and identify all the
duplicate numbers without my having to read each of them to find them
visually ?

I have been trying to calculate the sum value from the column of one
worksheet to a cell in another worksheet (all in the same workbook). I have
tried the VLOOKUP function where I establish the look_up_value and compare it
to an array in the other worksheet. It works except that ...

I have in column A (say A2:A100), strings containing names and dates
concatinated by "-".  I have extracted the names using Data>Text To Column.
The parsed names have been filtered to have unique names and are kept in
another column  say column F ( say F2 :F15).

My data table looks like this:
Date    Price    Volume
20070904    17.3    10
20070904    17.3    10

I have a list of phone numbers, some of the numbers have multiple numbers
associated with them, some do not.  When I autofilter, I see all the numbers
I need, but I cannot copy the autofilter list, nor can I select an option to
list all the numbers that I see when I open the ...

I am attempting to generate a random group of names from a list and am
having a bit of trouble.  In a previous posting I found the formula
=INDEX(A4:A15,INT(RAND()*(12-1)+1)), which is perfect for selecting a single
name.  The trouble that I have is that I need a random sample of ...

It's a pretty long formula for this one cell, which I am trying to make work.
Basically, I want it to where if there is nothing in the preceding cell, for
this cell to display nothing. However, I believe I have one too many
functions in the cell to be able to add the necessary ...

I'm trying to create an an invoice/receipt worksheet, so that when I input a
number in a cell, the adjacent cells automatically fill using predefined
information.
For example:

I have several OptionButtons grouped 2 and 2.
They are used to tell other formulas if a price shall be calculated per unit
or per load. For instance I've 2 OB's telling how to calculate the transport
price. I've a cell linked to one of the OB's and the formulas react

Is there a way to automatically fill data from a list.
For example, if I typed Denver in cell A1, the sheet would automatically put
in "Broncos" in cell A2.
Trying to enter one of a series of names of people, and their manager's name

I have a formula in a worksheet with two sheets, A and B
The formula is in SheetA =SheetB!G8-SheetB!G7+SheetB!G9+SheetB!G10
How can I copy this formula down in SheetA but always getting information 13
rows down in SheetB and then again 13 rows down?