Hi

I have data in sheet2 (data row7:row4000/ Title row1:6) and i want result in
sheet1
data is asorted type (consolidated from daily data)

sheet2 has many columns, where column 3 and 4 are to be checked
column 3 has branchname and 4 has brokercode

if brokercode is found in one branch only, skip that broker (no need to list)
if brokercode is found in more than one location, then list that branch
name, broker code and count transactions with that broker for each location.
result to show as below in sheet1:
Broker branch count
aaaa branch1 50
branch2 20
bbbb branch1 15
branch2 7
branch3 17

so if broker at single location is 800 then balance 3200 transactions must
have a break up like above