Seek'n'Destroy

[emukiss10]

Hello,

I have 2 sheets with lots of coumns and among them names and surnames.

I like excel to match columns E and F (name, surname) sheet 2 to columns F and G sheet 1 and if match compare column E sheet 1 to column B sheet 2 and if colum E has value 22 and column B sheet 2 do not have string "Partial" in it than remove that row from sheet 2.

the variables are:

22 - Partial
12 - Full
14 - old
21 - Part off
23 - part max

Its tricky

best regards
w.

 

[than_gold]

Hello,
As you said its tricky, could you please provide sample data in excel sheet, so that you will be able to get enough help.

 

[emukiss10]

sHEET 1

	A	B	C	D	E	F	G	H	I
1					Case	Name	Surname
2					22	Mike	Smith
3					21	Terry	Crews
4					22	Jey	Lo
5					12	Ann	Lons
6					23	Akira	Toriyama
7					14	Joe	Black
8					14	Hulk	Hogan
9					22	Lester	Bumham
10					22	Adam	Savage

<tbody>
</tbody>

SHEET 2

	A	B	C	D	E	F	G	H
1		CASE			NAME	SURNAME
2		Partial collection			Mike	Smith
3		semi Partial			Ann	Lons
4		Old reg			Joe	Black
5		Partial User			Lester	Bumham
6		Partial Collection			Adam	Savage

<tbody>
</tbody>

In this example, Row 3 Sheet 2 should be removed because Ann Lons do not have "FULL" in CASE column.
Sheet 1 should always be intact.

 

[emukiss10]

Guys, can't it be done? - sorry for spam I just need help.