If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eddy Stan" wrote in message
...
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