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

[TABLE="width: 529"]
<colgroup><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]PO Number[/TD]
[TD]SKU Code[/TD]
[TD]Qty Expected[/TD]
[TD]Qty Received[/TD]
[TD][/TD]
[TD]% Complete[/TD]
[/TR]
[TR]
[TD="align: right"]91776[/TD]
[TD="align: right"]484357[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120[/TD]
[TD] [/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD="align: right"]98502[/TD]
[TD="align: right"]386502[/TD]
[TD="align: right"]845[/TD]
[TD="align: right"]755[/TD]
[TD][/TD]
[TD="align: right"]-11%[/TD]
[/TR]
[TR]
[TD="align: right"]98502[/TD]
[TD="align: right"]386461[/TD]
[TD="align: right"]445[/TD]
[TD="align: right"]445[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD="align: right"]98502[/TD]
[TD="align: right"]386450[/TD]
[TD="align: right"]150[/TD]
[TD="align: right"]150[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD="align: right"]98502[/TD]
[TD="align: right"]386438[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD="align: right"]98968[/TD]
[TD="align: right"]525635[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]200[/TD]
[TD] [/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD="align: right"]128387[/TD]
[TD="align: right"]894552[/TD]
[TD="align: right"]192[/TD]
[TD="align: right"]192[/TD]
[TD] [/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD="align: right"]136164[/TD]
[TD="align: right"]735435[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]300[/TD]
[TD] [/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD="align: right"]136726[/TD]
[TD="align: right"]640975[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]-100%[/TD]
[/TR]
[TR]
[TD="align: right"]136726[/TD]
[TD="align: right"]640974[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]-100%[/TD]
[/TR]
[TR]
[TD="align: right"]136726[/TD]
[TD="align: right"]640972[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[/TR]
</tbody>[/TABLE]

 

[admiral100]

Hi ,

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