RE: Sorting?
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
if the first column is column A and the second column column D
in Add column E and enter in E1
=match(D1,A:A,0)
this column will indicate the row that the Column A name is in
depending on what you want to do, you can sort if there is a one to one
cooerelation in the column data.
"Darren" wrote:
> I have two columns one has a list of names; the second also has the same list
> of names. Column one is not in ascending or descending order and the order
> may not be changed. How can I get the names in the second column to match up
> with it corresponding name in the first column.
.
Relevant Pages
- RE: Printing wide columns
... > I have a spreadsheet that I want to print. ... but the second column is very wide. ... > able to print the first column. ... Prev by Date: ...
(microsoft.public.excel.misc) - Re: Memory Error while constructing Compound Dictionary
... > For the purpose of illustration let's suppose that the first column ... suppose the second column contains a ... this is a prelude to complicated meta-hack programming of the type Python ... in which case you either need a larger machine or a database. ...
(comp.lang.python) - Re: Sorting two columns of data
... you can record a small macro to cut the second column ... and paste it to the bottom of the first column, then select it and sort, ... > My intent was to be able to import data from a database and have the sort ...
(microsoft.public.excel.worksheet.functions) - Re: Fill Text Caption with Value
... which will display Bob when a new record is entered. ... Value is 'Bob' and not the '2'. ... I would like to show the second column ... the first column, ...
(microsoft.public.access.formscoding) - Re: The Psi Divide
... only read "Weyr Search" in that series), much of James Schmitz, ... I have trouble with the second column, ... were plenty of Galaxy and Analog short stories that had ... First column, I think. ...
(rec.arts.sf.written) |
|
