Re: Multiple comparison of list items.

"Paulie" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi, I need to give the users of my data a spreadsheet with the option
> of 'choosing' which items are relevant to their needs. I need them to
> make a preference choice between all the possible combinations, using
> VLOOKUP.
>
> Where my problem is though is as follows. I have a list of unique part
> numbers in a column. I need a macro to prepare a list that I can do
> some further comparitive work on. My list looks something like this.
>
> Column A
> 00237
> 00243
> 00251
> 00377
>
> I need to be able to cross reference each part number with each of the
> others, generating a list which wil look like the following:
>
> Column A   Column B
> 00237      00243
> 00237      00251
> 00237      00377
> 00243      00251
> 00243      00377
> 00251      00377
>
> In essence, I need to create a rows that have every possible
> combination of part numbers.
With Excel and VBA, the solution might be a first lesson in VBA programming
showing the difference between the use of FOR (when you know the number of
items) and WHILE (when you don't). I don't write it out because you may be a
student trying to skip his/her homework, and otherwise, I strongly advise to
take such a course.
Moreover, it is quite p[ossible that the original problem, which you did not
state, can be handled more efficiently in a different way, with another
macro and without the VLOOKUP

--
Rommert J. Casimir
Room B725
Tilburg University
P.O. Box 90153
5000 LE Tilburg, The Netherlands
tel 3113 4662016 fax 3113 4663377
http://infolab.uvt.nl/people/casimir/BIKA/RC_HOME.HTM

This message was sent from home,
De Zegge 7
5591 TT Heeze The Netherlands
tel 040-2060959/2060966

Computing was more fun when nobody got rich from it