Dear all
I have a problem, which i hope to solve with your help.
Out of a database I created a crosstable:
on the rows I have all the buy-trader and on the column are all the sell-trader. Seller and buyer can have the same identity. So in the row I have all the buyers doing a trade and in the crossingcells I will find the related seller.
As explained, a buyer can also be a seller. To know how many trades each single trader did with an other one (it does not matter if he was sell or buy side) I have to count the number of buys + number of sells he did in relation to this certain other trader.
What I am looking for is an automatic way to do this calculation. Are there any Add-ins or other tools I could use for that?
Attached you will find an example of what I am looking for. The upper table is the result I get from my access query and the second table is the format i would love to transform it. The red and green cells are highlited to clarify what I described in the upper part. buyer and seller & seller and buyer. The two numbers in the lower table is the total number of trades each trader did with the other -it does not matter if buyer or seller. Only important is the number of trades they did wtih each other.
Thanks in advance.
Cheers
Bookmarks