Help wth formulas

[browno]

Can someone help I have the below problem. The first column is the PO, each PO contains a SKU or multiple SKU's
There is also columns for expected and received qty's . At the end is a % against the SKU .
What I want to do is just to have what the % is based on the PO and if there is a line with a discrepancy % then I want this also.
The way it would look is:- PO , Line High %, total PO

Data is displayed below

PO Number	SKU Code	Qty Expected	Qty Received		% Complete
91776	484357	120	120		0%
98502	386502	845	755		-11%
98502	386461	445	445		0%
98502	386450	150	150		0%
98502	386438	60	60		0%
98968	525635	200	200		0%
128387	894552	192	192		0%
136164	735435	300	300		0%
136726	640975	30	0		-100%
136726	640974	84	0		-100%
136726	640972	60	60		0%

<colgroup><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>

 

[admiral100]

Hi ,

I think a pivot table will do the trick....