Combine complex arrays

[drluke]

I am combining data in several columns into one single column using this formula:
=OFFSET($F$2:$F$509,MOD(ROW()-ROW(ColumnData1),ROWS($F$2:$F$509)),TRUNC((ROW()-ROW(ColumnData1))/ROWS($F$2:$F$509),0),1,1)

Then I'm using this formula to ignore blank and zero cells, round the number and only look at cells that match a criteria:
{=IFERROR(INDEX(ROUND($R$2:$R$1527,2),SMALL(IF(ISNUMBER(1/$R$2:$R$1527),ROW($R$2:$R$1527)-ROW($F$2)+1),ROWS($S$2:S2))),"")}

I’m using named ranges:AccRange = columns I,J & K; ColumnData = column R, where I’m placing all my combined data; Period = col F.

Is there a way I can combine these formulas into one less complex formula? Or can I make my AccRange into into one single column using an array formula?

What can I add to my second formula to change negative numbers into positive ones (reverse the sign, but only for negative ones)?

Below is a sample of my data col A-K

[TABLE="width: 957"]
<colgroup><col width="87" span="11" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="class: xl68, width: 87, bgcolor: #F79646"]Client Code[/TD]
[TD="class: xl68, width: 87, bgcolor: #F79646"]Client Name[/TD]
[TD="class: xl68, width: 87, bgcolor: #F79646"]Loc[/TD]
[TD="class: xl68, width: 87, bgcolor: #F79646"]BS[/TD]
[TD="class: xl68, width: 87, bgcolor: #F79646"]Yr[/TD]
[TD="class: xl68, width: 87, bgcolor: #F79646"]Period[/TD]
[TD="class: xl68, width: 87, bgcolor: #F79646"]Fee %[/TD]
[TD="class: xl68, width: 87, bgcolor: #F79646"]Invoice Value[/TD]
[TD="class: xl68, width: 87, bgcolor: #F79646"]Mgt Fee[/TD]
[TD="class: xl71, width: 87, bgcolor: #D8E4BC"]Payments[/TD]
[TD="class: xl71, width: 87, bgcolor: #D8E4BC"]Adjmts[/TD]
[/TR]
[TR]
[TD="class: xl69"]CBAN700[/TD]
[TD="class: xl69"]BANES RECRUITMENT[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]1[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 2,405.00 [/TD]
[TD="class: xl75, align: center"]24.05[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CBBC703[/TD]
[TD="class: xl69"]BOURNEMOUTH BC PNs[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]1[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 10,012.75 [/TD]
[TD="class: xl75, align: center"]100.13[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CBCC001[/TD]
[TD="class: xl69"]Birmingham City Council REC[/TD]
[TD="class: xl70, align: center"]300[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]1[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 47,384.92 [/TD]
[TD="class: xl75, align: center"]473.85[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CBCC001[/TD]
[TD="class: xl69"]Birmingham City Council REC[/TD]
[TD="class: xl70, align: center"]300[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]1[/TD]
[TD="class: xl72, align: right"]2. %[/TD]
[TD="class: xl73, align: center"] 46,455.80 [/TD]
[TD="class: xl77, bgcolor: yellow, align: center"]929.12[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CBCC002[/TD]
[TD="class: xl69"]Birmingham City Council PNs[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]1[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 20,004.24 [/TD]
[TD="class: xl75, align: center"]200.04[/TD]
[TD="class: xl76, align: right"]-2678.75[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CBCC002[/TD]
[TD="class: xl69"]Birmingham City Council PNs[/TD]
[TD="class: xl70, align: center"]300[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]2[/TD]
[TD="class: xl72, align: right"]2. %[/TD]
[TD="class: xl73, align: center"] 19,612.00 [/TD]
[TD="class: xl77, bgcolor: yellow, align: center"]392.24[/TD]
[TD="class: xl76, align: right"]-435.21[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CBPN700[/TD]
[TD="class: xl69"]BANES PUBLIC NOTICES[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]2[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 14,054.01 [/TD]
[TD="class: xl75, align: center"]140.54[/TD]
[TD="class: xl76, align: right"]-2172.28[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CBUC006[/TD]
[TD="class: xl69"]Buckinghamshire County Council[/TD]
[TD="class: xl70, align: center"]300[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]2[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 2,816.25 [/TD]
[TD="class: xl75, align: center"]28.16[/TD]
[TD="class: xl76, align: right"]-1554.69[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CCCC604[/TD]
[TD="class: xl69"]Coventry City Council REC[/TD]
[TD="class: xl70, align: center"]300[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]2[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 8,541.70 [/TD]
[TD="class: xl75, align: center"]85.42[/TD]
[TD="class: xl76, align: right"]-494.86[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CCCC700[/TD]
[TD="class: xl69"]CAMBRIDGE CITY COUNCIL PN[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 4,309.07 [/TD]
[TD="class: xl75, align: center"]43.09[/TD]
[TD="class: xl76, align: right"]-1239.12[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CCCC701[/TD]
[TD="class: xl69"]Cambridgeshire County Council[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 25,504.40 [/TD]
[TD="class: xl75, align: center"]255.04[/TD]
[TD="class: xl76, align: right"]-1481.00[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CCCC704[/TD]
[TD="class: xl69"]COVENTRY CITY COUNCIL PN[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 15,873.28 [/TD]
[TD="class: xl75, align: center"]158.73[/TD]
[TD="class: xl76, align: right"]-138.34[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CCCC706[/TD]
[TD="class: xl69"]COVENTRY CITY COUNCIL - Schools[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 919.81 [/TD]
[TD="class: xl75, align: center"]9.20[/TD]
[TD="class: xl76, align: right"]-639.31[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CCDC700[/TD]
[TD="class: xl69"]CRAVEN DISTRICT COUNCIL[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 3,232.64 [/TD]
[TD="class: xl75, align: center"]32.33[/TD]
[TD="class: xl76, align: right"]-8.92[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CCEC700[/TD]
[TD="class: xl69"]CHESHIRE EAST COUNCIL (PN)[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 11,620.54 [/TD]
[TD="class: xl75, align: center"]116.21[/TD]
[TD="class: xl76, align: right"]-99.55[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CCSR001[/TD]
[TD="class: xl69"]Government Recruitment Sevice[/TD]
[TD="class: xl70, align: center"]316[/TD]
[TD="class: xl70, align: center"]007[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 257,895.48 [/TD]
[TD="class: xl75, align: center"]2578.95[/TD]
[TD="class: xl76, align: right"]-113.56[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CCSR002[/TD]
[TD="class: xl69"]Government Recruitment service[/TD]
[TD="class: xl70, align: center"]208[/TD]
[TD="class: xl70, align: center"]007[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 4,230.79 [/TD]
[TD="class: xl75, align: center"]42.31[/TD]
[TD="class: xl76, align: right"]-195.80[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CDCC700[/TD]
[TD="class: xl69"]Derby City Council[/TD]
[TD="class: xl70, align: center"]300[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 4,944.04 [/TD]
[TD="class: xl75, align: center"]49.44[/TD]
[TD="class: xl76, align: right"]-1322.77[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CDDC001[/TD]
[TD="class: xl69"]Daventry District Council PNS[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 6,992.12 [/TD]
[TD="class: xl75, align: center"]69.92[/TD]
[TD="class: xl76, align: right"]-385.31[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CDDC700[/TD]
[TD="class: xl69"]DAVENTRY DISTRICT COUNCIL REC[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 16,122.00 [/TD]
[TD="class: xl75, align: center"]161.22[/TD]
[TD="class: xl76, align: right"]-92.45[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CDPS003[/TD]
[TD="class: xl69"]Parliamentary Digital Service[/TD]
[TD="class: xl70, align: center"]107[/TD]
[TD="class: xl70, align: center"]021[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 3,500.00 [/TD]
[TD="class: xl75, align: center"]35.00[/TD]
[TD="class: xl76, align: right"]-177.45[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CESS900[/TD]
[TD="class: xl69"]Essex C C (Public Notice/Tenders)[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 45,663.05 [/TD]
[TD="class: xl75, align: center"]456.63[/TD]
[TD="class: xl76, align: right"]-235.94[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CHBB700[/TD]
[TD="class: xl69"]HINCKLEY & BOSWORTH BC[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 5,550.55 [/TD]
[TD="class: xl75, align: center"]55.51[/TD]
[TD="class: xl76, align: right"]-796.31[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CHIG006[/TD]
[TD="class: xl69"]Highways England[/TD]
[TD="class: xl70, align: center"]104[/TD]
[TD="class: xl70, align: center"]007[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]3[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 10,376.22 [/TD]
[TD="class: xl75, align: center"]103.76[/TD]
[TD="class: xl76, align: right"]-0.19[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CHSC700[/TD]
[TD="class: xl69"]Herts for Learning Ltd[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]009[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]4[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 559.65 [/TD]
[TD="class: xl75, align: center"]5.60[/TD]
[TD="class: xl76, align: right"]-0.11[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CHST002[/TD]
[TD="class: xl69"]High Speed Two (HS2) Ltd[/TD]
[TD="class: xl70, align: center"]320[/TD]
[TD="class: xl70, align: center"]007[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]4[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 819.05 [/TD]
[TD="class: xl75, align: center"]8.19[/TD]
[TD="class: xl76, align: right"]-15678.54[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CKCC702[/TD]
[TD="class: xl69"]Kent County Council[/TD]
[TD="class: xl70, align: center"]307[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]4[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 12,700.05 [/TD]
[TD="class: xl75, align: center"]127.00[/TD]
[TD="class: xl76, align: right"]-99.01[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CLBO700[/TD]
[TD="class: xl69"]LB Barnet Corp & Schools[/TD]
[TD="class: xl70, align: center"]308[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]4[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 4,871.42 [/TD]
[TD="class: xl75, align: center"]48.71[/TD]
[TD="class: xl76, align: right"]-159.92[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CLCC702[/TD]
[TD="class: xl69"]LEICESTERSHIRE COUNTY COUNCIL (REC)[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]4[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 1,855.00 [/TD]
[TD="class: xl75, align: center"]18.55[/TD]
[TD="class: xl76, align: right"]-140.00[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CLGA700[/TD]
[TD="class: xl69"]LOCAL GOVERNMENT ASSOCIATION[/TD]
[TD="class: xl70, align: center"]300[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]4[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 1,681.00 [/TD]
[TD="class: xl75, align: center"]16.81[/TD]
[TD="class: xl76, align: right"]-2985.19[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CMOJ001[/TD]
[TD="class: xl69"]Ministry of Justice[/TD]
[TD="class: xl70, align: center"]100[/TD]
[TD="class: xl70, align: center"]007[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]4[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 9,920.00 [/TD]
[TD="class: xl75, align: center"]99.20[/TD]
[TD="class: xl76, align: right"]-19.47[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CNCC705[/TD]
[TD="class: xl69"]NORTHUMBERLAND COUNTY COUNCIL REC[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]4[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 3,214.86 [/TD]
[TD="class: xl75, align: center"]32.15[/TD]
[TD="class: xl76, align: right"]-659.98[/TD]
[TD="class: xl75, align: center"]27.75[/TD]
[/TR]
[TR]
[TD="class: xl69"]CNTC700[/TD]
[TD="class: xl69"]NORTH TYNESIDE COUNCIL PNS[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]4[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 7,271.64 [/TD]
[TD="class: xl75, align: center"]72.72[/TD]
[TD="class: xl76, align: right"]-238.17[/TD]
[TD="class: xl75, align: center"]33.55[/TD]
[/TR]
[TR]
[TD="class: xl69"]CPCC700[/TD]
[TD="class: xl69"]PETERBOROUGH CITY COUNCIL[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]4[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 5,706.10 [/TD]
[TD="class: xl75, align: center"]57.06[/TD]
[TD="class: xl76, align: right"]-59.95[/TD]
[TD="class: xl75, align: center"]142.95[/TD]
[/TR]
[TR]
[TD="class: xl69"]CRCB700[/TD]
[TD="class: xl69"]REDCAR & CLEVELAND PNs[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]5[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 3,318.90 [/TD]
[TD="class: xl75, align: center"]33.19[/TD]
[TD="class: xl76, align: right"]-37.44[/TD]
[TD="class: xl75, align: center"]212.39[/TD]
[/TR]
[TR]
[TD="class: xl69"]CRED600[/TD]
[TD="class: xl69"]Redcar & Cleveland BC REC[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]5[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 7,267.50 [/TD]
[TD="class: xl75, align: center"]72.68[/TD]
[TD="class: xl76, align: right"]-2282.97[/TD]
[TD="class: xl75, align: center"]46.35[/TD]
[/TR]
[TR]
[TD="class: xl69"]CSBC700[/TD]
[TD="class: xl69"]Slough Borough Council[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]5[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 23,556.62 [/TD]
[TD="class: xl75, align: center"]235.57[/TD]
[TD="class: xl76, align: right"]-395.70[/TD]
[TD="class: xl75, align: center"]361.77[/TD]
[/TR]
[TR]
[TD="class: xl69"]CSGC600[/TD]
[TD="class: xl69"]South Gloucestershire Council REC[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]5[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 4,171.34 [/TD]
[TD="class: xl75, align: center"]41.71[/TD]
[TD="class: xl76, align: right"]-1.86[/TD]
[TD="class: xl75, align: center"]489.26[/TD]
[/TR]
[TR]
[TD="class: xl69"]CSGC700[/TD]
[TD="class: xl69"]South Gloucestershire Council PN[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]5[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 12,847.58 [/TD]
[TD="class: xl75, align: center"]128.48[/TD]
[TD="class: xl76, align: right"]-1080.06[/TD]
[TD="class: xl75, align: center"]101.34[/TD]
[/TR]
[TR]
[TD="class: xl69"]CSMB700[/TD]
[TD="class: xl69"]SANDWELL MBC - PNs[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]5[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 2,629.45 [/TD]
[TD="class: xl75, align: center"]26.29[/TD]
[TD="class: xl76, align: right"]-544.43[/TD]
[TD="class: xl75, align: center"]1.57[/TD]
[/TR]
[TR]
[TD="class: xl69"]CSOL700[/TD]
[TD="class: xl69"]Solihull MBC Schools[/TD]
[TD="class: xl70, align: center"]300[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]5[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 985.62 [/TD]
[TD="class: xl75, align: center"]9.86[/TD]
[TD="class: xl76, align: right"]-206.69[/TD]
[TD="class: xl75, align: center"]512.83[/TD]
[/TR]
[TR]
[TD="class: xl69"]CSOL701[/TD]
[TD="class: xl69"]Solihull MBC Rec[/TD]
[TD="class: xl70, align: center"]300[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]5[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 6,521.08 [/TD]
[TD="class: xl75, align: center"]65.21[/TD]
[TD="class: xl76, align: right"]-361.43[/TD]
[TD="class: xl75, align: center"]236.35[/TD]
[/TR]
[TR]
[TD="class: xl69"]CSOL702[/TD]
[TD="class: xl69"]Solihull MBC PN[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]5[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 3,066.61 [/TD]
[TD="class: xl75, align: center"]30.67[/TD]
[TD="class: xl76, align: right"]-1.19[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CSOM005[/TD]
[TD="class: xl69"]Somerset County Council[/TD]
[TD="class: xl70, align: center"]300[/TD]
[TD="class: xl70, align: center"]044[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]5[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 1,200.00 [/TD]
[TD="class: xl75, align: center"]12.00[/TD]
[TD="class: xl76, align: right"]-11.02[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CSOT010[/TD]
[TD="class: xl69"]Stoke on Trent City Council[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]5[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 4,265.23 [/TD]
[TD="class: xl75, align: center"]42.65[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CSOT010[/TD]
[TD="class: xl69"]Stoke on Trent City Council[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]5[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 4,223.00 [/TD]
[TD="class: xl77, bgcolor: yellow, align: center"]42.23[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CTLR002[/TD]
[TD="class: xl69"]The Land Registry[/TD]
[TD="class: xl70, align: center"]110[/TD]
[TD="class: xl70, align: center"]007[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]5[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] - [/TD]
[TD="class: xl77, bgcolor: yellow, align: center"]0.00[/TD]
[TD="class: xl76, align: right"]-398.35[/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CSTS700[/TD]
[TD="class: xl69"]Stoke on Trent City Council[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]6[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 10,666.00 [/TD]
[TD="class: xl77, bgcolor: yellow, align: center"]106.66[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76, align: right"]-218.12[/TD]
[/TR]
[TR]
[TD="class: xl69"]CTOH002[/TD]
[TD="class: xl69"]London Borough of Tower Hamlets[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]6[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 9,506.00 [/TD]
[TD="class: xl75, align: center"]95.06[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CWCC004[/TD]
[TD="class: xl69"]Warwickshire County Council - Rec[/TD]
[TD="class: xl70, align: center"]300[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]6[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 12,948.00 [/TD]
[TD="class: xl75, align: center"]129.48[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CWCC007[/TD]
[TD="class: xl69"]Warwickshire CC PNs[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]6[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 20,913.28 [/TD]
[TD="class: xl75, align: center"]209.13[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CWCC010[/TD]
[TD="class: xl69"]Warwickshire CC SCHOOLS[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]6[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 8,355.00 [/TD]
[TD="class: xl75, align: center"]83.55[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CWMP700[/TD]
[TD="class: xl69"]West Midlands Police[/TD]
[TD="class: xl70, align: center"]112[/TD]
[TD="class: xl70, align: center"]044[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]6[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 1,117.70 [/TD]
[TD="class: xl75, align: center"]11.18[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CWOR009[/TD]
[TD="class: xl69"]Worcestershire CC PN[/TD]
[TD="class: xl70, align: center"]500[/TD]
[TD="class: xl70, align: center"]031[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]6[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 22,434.91 [/TD]
[TD="class: xl75, align: center"]224.35[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CWOR009[/TD]
[TD="class: xl69"]Worcestershire CC PN[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]6[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 22,212.80 [/TD]
[TD="class: xl77, bgcolor: yellow, align: center"]222.13[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76"] [/TD]
[/TR]
[TR]
[TD="class: xl69"]CWOR700[/TD]
[TD="class: xl69"]Worcestershire CC Rec[/TD]
[TD="class: xl70, align: center"]400[/TD]
[TD="class: xl70, align: center"]014[/TD]
[TD="class: xl70, align: center"]2018[/TD]
[TD="class: xl74, align: center"]6[/TD]
[TD="class: xl72, align: right"]1. %[/TD]
[TD="class: xl73, align: center"] 485.00 [/TD]
[TD="class: xl77, bgcolor: yellow, align: center"]4.85[/TD]
[TD="class: xl76"] [/TD]
[TD="class: xl76"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[DRSteele]

I only know part of the answer. If you wish to convert the negative numbers to postive numbers, there are several ways. One involves function IF, but that can mean large array forumlas. A simple way to remove the negation is to square the number and use function SQRT. E.g., If A1 contains the topic number of -72.5, then =SQRT(A1^2) will convert it to 72.5 but will not alter positive numbers.