papi84
06-17-2009, 03:29 AM
Hello everybody :)
i have been a long time a fan of this forum and now i am part of it :)
so, i have the following problem that i just caaaaaaant' solve :dunno
i have two tables respectively in two sheets: Sheet1 and Sheet2. The first table looks something like that:
Product Support
Computer HP
Printer IBM
Telephone Motorola
Computer IBM
Computer Dell
and the second one like that:
Support OpSystem Version IntNumber
HP Win2003 ix86 1.02
HP Win2000 ix86 0.76
IBM Win2003 ix86 2.2
Dell Win2003 ix86 1.2
Motorolla Win2003 ix86 2.1
Dell Win2000 ix86 1.1.1
So, for example, i have to extract all the Supporters for the Product "Computer"....that means HP, IBM, Dell
then i have to use this data (HP, IBM, Dell) in the second table and to eliminate the rows that do not have HP, IBM, Dell as Support. That means that in the second table Motorola should be eliminated.
I 'google'-d for some quite time but i couldn't find something that could help me.
Please heeelp :help
i have been a long time a fan of this forum and now i am part of it :)
so, i have the following problem that i just caaaaaaant' solve :dunno
i have two tables respectively in two sheets: Sheet1 and Sheet2. The first table looks something like that:
Product Support
Computer HP
Printer IBM
Telephone Motorola
Computer IBM
Computer Dell
and the second one like that:
Support OpSystem Version IntNumber
HP Win2003 ix86 1.02
HP Win2000 ix86 0.76
IBM Win2003 ix86 2.2
Dell Win2003 ix86 1.2
Motorolla Win2003 ix86 2.1
Dell Win2000 ix86 1.1.1
So, for example, i have to extract all the Supporters for the Product "Computer"....that means HP, IBM, Dell
then i have to use this data (HP, IBM, Dell) in the second table and to eliminate the rows that do not have HP, IBM, Dell as Support. That means that in the second table Motorola should be eliminated.
I 'google'-d for some quite time but i couldn't find something that could help me.
Please heeelp :help