View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
broogle broogle is offline
external usenet poster
 
Posts: 67
Default Conditional sort

Let say I have 2 Columns (A = Section, B=Class).
Section Class Value
Section1 A 1
Section2 B 1
Section3 A 1
Section2 D 1
Section1 B 1
Section2 A 1
Section1 B 1
Section1 E 1
Section1 A 1
Section2 A 1

The result I want is :
Column A,B, C - is sorted, but if Section and Class is the same, only
one will be displayed and the value is added in column C.
The result will be :

Section Class Value
Section1 A 2
Section1 B 2
Section1 E 1
Section2 A 2
Section2 B 1
Section2 D 1
Section3 A 1

Would apreciate your help.
Thanks