Hi All,

Im new to posting on this forum and have learnt alot viewing it
frequently!

I have a query with regards to excel formula. If not allowed to post
queries, i do apologise.

Please see attached jpg. The data is on the left. On the right is a
"summary" of this data that i need to automate into formulas
(Everything in RED needs to be dynamic).
It also needs to stay in this exact format. No additional cells or
fields can be created.
Can anybody assist?

Thanks in advance.
Regards
Jarad.


+-------------------------------------------------------------------+
|Filename: Query.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4409 |
+-------------------------------------------------------------------+

--
Jarad
------------------------------------------------------------------------
Jarad's Profile: http://www.excelforum.com/member.php...o&userid=32072
View this thread: http://www.excelforum.com/showthread...hreadid=518209