#### TryingToLearn

##### Well-known Member

- Joined
- Sep 10, 2003

- Messages
- 723

I need to find out how many entries match in columns a b c f

A B C D E F

Style Series Color A B Size

DH 100 WH 20 30 84

DH 100 WH 20 30 84

DPD 100 WH 20 30 102

DPD 100 WH 20 30 98

DPD 100 WH 20 30 98

C1 100 WH 20 30 88

C1 100 WH 20 30 88

DH 100 WH 20 30 88

DH 100 WH 20 30 88

DH 100 WH 20 30 71

BH 200 WH 20 30 67

BH 200 WH 20 30 67

result to be:

Q Style Series Color Size

2 DH 100 WH 84

1 DPD 100 WH 102

2 DPD 100 WH 98

2 C1 100 WH 88

2 DH 100 WH 88

1 DH 100 WH 71

2 BH 200 WH 67

(ideally, sorted by 2nd column of results)

Thanks!