View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Calle Calle is offline
external usenet poster
 
Posts: 70
Default Need help with sorting of three columns

Hmm I try to describe it a bit better:

column 1:----------- column 2:----------- column 3:

Postoffice1 --------salesman#1 ---------------1
Postoffice1 --------salesman#1 --------------4
Postoffice1 --------salesman#1 --------------1
Postoffice2 --------salesman#1 --------------2
Postoffice3 --------salesman#2 --------------2
Postoffice4 --------salesman#1 --------------3

This is the result I want:
Postoffice1 --------salesman#1 --------------6
Postoffice2 --------salesman#1 --------------2
Postoffice3 --------salesman#2 --------------2
Postoffice4 --------salesman#1 --------------3