3 Seasons only

[nitebyfly]

I have 21K rows of data where I need to delete entries under the following criteria;

delete those rows that only match one season OR
delete those rows that only match two seasons.

Keep those rows that where a name matches three seasons
(Fall, Jan(winter), Spring)

A B C
1 last first season
2 smith james fall
3 smith james jan(winter)
4 smith james spring
5 taylor john fall
6 taylor john spring
7 sand fresh fall

In this example the goal would be to delete or mark for deletion rows 5, 6 & 7.

Thank you for any help you can provide.

Tim

 

[texasalynn]

ahhhhh! I see now, so you could instead create a helper column with a formula

Excel Workbook
	A	B	C	D
1	last	first	season
2	smith	james	fall	3
3	smith	james	jan(winter)	3
4	smith	james	spring	3
5	taylor	john	fall	2
6	taylor	john	spring	2
7	sand	fresh	fall	1
Sheet1

Excel 2003

Cell Formulas
Range	Formula
D2	=SUMPRODUCT(--($A$2:$A$7=A2),--($B$2:$B$7=B2))

Copy the formula down, then do a auto filter for the helper column that is less than 3. Delete those lines

 

[nitebyfly]

I LOVE EXCEL PEOPLE! Thank you for your staying power. Yes, that does work on the example. EXCELLENT.

Thank you, thank you, thank you.

Tim

 

[texasalynn]

your welcome - thanks for the feedback