TryingToLearn
Well-known Member
- Joined
- Sep 10, 2003
- Messages
- 730
I have 6 columns of data where I need to sum the count of identical entrys in 4 of the columns. Can't get VBHTML to work yet so pardon my alignment!
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!
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!