I have a series of names in a coulmn in Sheet1. I have a range of data
in sheet2 that looks like this.
Name1    DataType1    DataType2
Name2    DataType1    DataType2

How can I extract the first entries for each key in Excel from the following
4 columns ?
(i.e. the maximum value of cocatenated columns 1,2 &4  e.g. JohnSmith200).  I
already concatenated the first 2 columns as the key and SUMmed the "Values"

We have a excel workbook we use to keep track of inventory and there are
several worsheets inside that hold different sets of data.  The problem is
that all of the sudden it will not let us add any more worsheets to the
workbook.  There are only 10 worksheets right now so I know ...

Can we change the default templates location in XL2K?  I think I did
it once by using the change startup folder location by accident, but I
can't remember.  An archives search in 3 Excel ngs didn't yield
results yet.  TIA.

My problem is i have made a worksheet for work to enter data for testin
we perform, but on this worksheet i need to copy a graph from anothe
worksheet. Problem is the graph worksheet cell widths are vey smal
like 1.29 (38 cells) and height is 3.75 (93 cells), now if i copy the

Whenever I delete a row of data on my spreadsheet and then try to resort
(ascending or descending) it acts as though the information is still there or
it will sort the rows between the empty rows separately from the rest of the
spreadsheet.

Where do I find the sheet selector that was promised for signing up fo
exceltip.com newsletter? I can't seem to find it anywhere.
Thanks,
Ily

Hi again all
How do I programatically select the range of cells in Columns B through D by
date in the following scenario:
Column A     Column B    Column C    Column D

Hi. I am trying to find a formula that would lookup the value of a cel
at varying locations in a list. for example =AH3 + 25  to lookup cel
AH28 where the number 25 is taken from a calculation. any suggestion
would be appreciated

Cell A1 may have a number entered.
Cells A2 thru A13 may have numbers entered.
I want cell A14 to display which ever has the higher value.... A1 or the sum
of cell range A2:A13.

I receive data dump from Crystal Reports into an Excel format.  The
text data in some cells contains special characters - mostly the Tab
and leading/trailing spaces.  I can trim the data and eliminate the
leading/trailing spaces but I can't seem to eliminate the Tabs.

I'm referencing a time value in Worksheet "A" from the Data worksheet "B"
like this;  =Data!A1.  Cell A1 is formatted as time and shows as 01:00, and
I need it to be a general number (just a 1) in Worksheet "A" so I can divide
it by another general number.  Cells B1 & B2 are ...

I am trying to import a database data in excel from db_vista database
and it limits the output to 25 rows. Does anybody know how to increase
the output?

We need to set the range from text sent to us. Below is an exmple. Can
anyone help as the issue is that normally the range the example below only
references cells [C4, B2, D8] in a sheet and not all the sheets and cells
[Sheet1!C4, Sheet2!B2, Sheet3!D8].

I have a report that uses columns with an X to indicate that a particular
attribute applies to that row. Like this,
ModelABC    X    XX          XXXXX       X.
I need to make this report more attractive when displayed on a web site. I