Consider the following:
Col A        Col B         Col C       Col D
ERDF        45,678       JKNM       23,234
JKNM        12,909       ABCD       54,567

When I open my excel document it opens the same document twice, after the
file name it as :1 and the 2nd document (same as the 1st) has :2 after the
file name.  You can view each of these files by clicking on Windows and
selecting the other document.  I'm not sure how my file got ...

I have 3 date fields:
STARTDTE      ENDDTE           REVDTE
08/22/2007     12/15/2007                          If REVDTE NULL use STARTDTE
08/22/2007     12/15/2007      09/01/2007   If REVDATE NOT NULL use REVDTE

Is it still the case where the median formula can not be used in pivot
tables. If this can be done, how do I add it?
Thanks,

I have inherited a spreadsheet with over 5000 range names. Unfortunately,
these range names were not created intuitively and have little meaning to
what they refer to. I would like to have a version of this workbook with only
the cell range references in the formulas for ease of ...

need to flag in 3rd column when data based on 2 other columns is repeated
I have two columns where data needs to be validated based on the two columns.
Trying to get the Sumproduct() to do it for me but its not coming back right
Column

1.  I want average from cell  B 51 to the last cell of column B.  can I write
=AVERAGE(B51:B65005)
2. How can I format cell  B 51 to the last cell of column B
Thanks

As you know, when VLOOKUP uses "FALSE" for Range_lookup and no exact match
is made, Excel produces an output "#N/A".
This is messing up formulae that are based on the output of cells where this
formula is used, where then produce the same "#N/A".

Hi.  I have two sheets I need to find matches from sheet1 against
sheet2 looking for the first 6 characters only.
example:
sheet1            sheet2        MATCH RESULTS

I have entered a formula in a cell and have copied it to several other
adjacent cells. Now I want to change all the formulas to absolute references
so I can sort the list. How can I change a group of cells all at once rather
than editing each cell and adding the $'s.

I have a very simple table of cost centre numbers and associated cost centre
names in the next column.
This table in a spreadsheet worksheet, links directly to our accounts package
through a template function supplied our accounts package supplier. This

I have a list of data where I want to know, by day, how many time different
items occur.
I have tried several possibilities with no luck.  I would like to use a
pivot table but my data is not processing correctly.

I am trying to make a Cash Sale sheet in Excel and i would like for one of
the cells to always go up a number when i open that document up, is that
possible?

My ss recently started displaying a partial calculation in the formula.  The
result is correct, but I need to be able to see original entry.  To simplify,
if I enter 2*5*3 the formula displays 10*3.   I am sure I have accidently
clicked something, but I don't know what.  Any ...

I'm trying to design a trade checker for an NBA fantasy league I'm in.
I have a list of teams in a range (named "Teams"), a list of players
in each team in a range (named "Players"), and a list of the salaries
for all the players in a range (named "Salaries").