Transpose - but with formula - Paste across, but move cell references down & over one

jdawson1237

New Member
Joined
Dec 5, 2017
Messages
7
Can anyone help me out here. I'm dealing with a pretty messy Cohord Analysis and I need to be able to paste across a row, but have the cell references move over one and down one each time I paste to the right.

Does that make sense?

Said another way, normally when you paste to the right, it moves your cell reference over one to the right.

How do I make it go down one as well while pasting on the same row?

Thanks in advance!
 
Here's an example of my data. So if I want to average the bottom 3 or 6 cells in each column... copy/paste my average formula to the right, but have the references move up one row each time...

[B]Excel 2013/2016[/B][TABLE]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH][/TH]
[TH]A[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[TH]I[/TH]
[TH]J[/TH]
[/TR]
</thead><tbody>[TR]
[TD="align: center"]153[/TD]
[TD="align: right"]Sep-16[/TD]
[TD="align: center"]5.3%[/TD]
[TD="align: center"]18.8%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]1.6%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]1.7%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]0.8%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]1.4%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]1.7%[/TD]
[/TR]
[TR]
[TD="align: center"]154[/TD]
[TD="align: right"]Oct-16[/TD]
[TD="align: center"]9.4%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]11.4%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]2.9%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]1.6%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]1.6%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]1.3%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]0.9%[/TD]
[/TR]
[TR]
[TD="align: center"]155[/TD]
[TD="align: right"]Nov-16[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]11.7%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]12.1%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]2.6%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]2.1%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]2.1%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]0.5%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]1.4%[/TD]
[/TR]
[TR]
[TD="align: center"]156[/TD]
[TD="align: right"]Dec-16[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]15.0%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]7.8%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]4.4%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]3.4%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]0.2%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]1.2%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]1.0%[/TD]
[/TR]
[TR]
[TD="align: center"]157[/TD]
[TD="align: right"]Jan-17[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]18.6%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]8.0%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]4.4%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]0.9%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]1.5%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]0.5%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]0.5%[/TD]
[/TR]
[TR]
[TD="align: center"]158[/TD]
[TD="align: right"]Feb-17[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]15.6%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]13.8%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]1.1%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]1.3%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]0.8%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]0.6%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]1.5%[/TD]
[/TR]
[TR]
[TD="align: center"]159[/TD]
[TD="align: right"]Mar-17[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]21.1%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]11.4%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]2.7%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]1.3%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]0.7%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]2.1%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]0.3%[/TD]
[/TR]
[TR]
[TD="align: center"]160[/TD]
[TD="align: right"]Apr-17[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=D9D9D9]#D9D9D9[/URL] , align: center"]15.5%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]16.4%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]2.6%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]1.1%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]1.4%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]0.3%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]0.2%[/TD]
[/TR]
[TR]
[TD="align: center"]161[/TD]
[TD="align: right"]May-17[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]16.3%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]17.7%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]3.2%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]1.5%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]0.2%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]0.6%[/TD]
[TD="align: center"]-[/TD]
[/TR]
[TR]
[TD="align: center"]162[/TD]
[TD="align: right"]Jun-17[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]21.3%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]13.2%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]5.9%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]1.7%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]1.0%[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[/TR]
[TR]
[TD="align: center"]163[/TD]
[TD="align: right"]Jul-17[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=BFBFBF]#BFBFBF[/URL] , align: center"]19.2%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]17.4%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]4.7%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]1.6%[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[/TR]
[TR]
[TD="align: center"]164[/TD]
[TD="align: right"]Aug-17[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]21.7%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]16.1%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]3.4%[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[/TR]
[TR]
[TD="align: center"]165[/TD]
[TD="align: right"]Sep-17[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]22.1%[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]12.9%[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[/TR]
[TR]
[TD="align: center"]166[/TD]
[TD="align: right"]Oct-17[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=A6A6A6]#A6A6A6[/URL] , align: center"]22.9%[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[/TR]
[TR]
[TD="align: center"]167[/TD]
[TD="align: right"]Nov-17[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[TD="align: center"]-[/TD]
[/TR]
</tbody>[/TABLE]
[CENTER][COLOR=#161120][B]Inland CV[/B][/COLOR][/CENTER]

[TABLE="width: 85%"]
<tbody>[TR]
[TD][B]Worksheet Formulas[/B][TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A153[/TH]
[TD]=+A38[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A154[/TH]
[TD]=+A39[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A155[/TH]
[TD]=+A40[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A156[/TH]
[TD]=+A41[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A157[/TH]
[TD]=+A42[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A158[/TH]
[TD]=+A43[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A159[/TH]
[TD]=+A44[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A160[/TH]
[TD]=+A45[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A161[/TH]
[TD]=+A46[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A162[/TH]
[TD]=+A47[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A163[/TH]
[TD]=+A48[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A164[/TH]
[TD]=+A49[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A165[/TH]
[TD]=+A50[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A166[/TH]
[TD]=+A51[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A167[/TH]
[TD]=+A52[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D153[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D38/$B38,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D38/$B38,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E153[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E38/$B38,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E38/$B38,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F153[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F38/$B38,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F38/$B38,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G153[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G38/$B38,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G38/$B38,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H153[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H38/$B38,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H38/$B38,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I153[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I38/$B38,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I38/$B38,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J153[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J38/$B38,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J38/$B38,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D154[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D39/$B39,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D39/$B39,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E154[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E39/$B39,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E39/$B39,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F154[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F39/$B39,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F39/$B39,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G154[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G39/$B39,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G39/$B39,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H154[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H39/$B39,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H39/$B39,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I154[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I39/$B39,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I39/$B39,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J154[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J39/$B39,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J39/$B39,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D155[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D40/$B40,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D40/$B40,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E155[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E40/$B40,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E40/$B40,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F155[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F40/$B40,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F40/$B40,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G155[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G40/$B40,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G40/$B40,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H155[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H40/$B40,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H40/$B40,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I155[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I40/$B40,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I40/$B40,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J155[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J40/$B40,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J40/$B40,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D156[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D41/$B41,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D41/$B41,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E156[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E41/$B41,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E41/$B41,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F156[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F41/$B41,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F41/$B41,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G156[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G41/$B41,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G41/$B41,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H156[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H41/$B41,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H41/$B41,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I156[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I41/$B41,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I41/$B41,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J156[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J41/$B41,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J41/$B41,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D157[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D42/$B42,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D42/$B42,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E157[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E42/$B42,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E42/$B42,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F157[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F42/$B42,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F42/$B42,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G157[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G42/$B42,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G42/$B42,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H157[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H42/$B42,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H42/$B42,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I157[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I42/$B42,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I42/$B42,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J157[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J42/$B42,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J42/$B42,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D158[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D43/$B43,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D43/$B43,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E158[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E43/$B43,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E43/$B43,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F158[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F43/$B43,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F43/$B43,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G158[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G43/$B43,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G43/$B43,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H158[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H43/$B43,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H43/$B43,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I158[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I43/$B43,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I43/$B43,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J158[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J43/$B43,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J43/$B43,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D159[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D44/$B44,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D44/$B44,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E159[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E44/$B44,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E44/$B44,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F159[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F44/$B44,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F44/$B44,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G159[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G44/$B44,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G44/$B44,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H159[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H44/$B44,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H44/$B44,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I159[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I44/$B44,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I44/$B44,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J159[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J44/$B44,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J44/$B44,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D160[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D45/$B45,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D45/$B45,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E160[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E45/$B45,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E45/$B45,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F160[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F45/$B45,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F45/$B45,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G160[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G45/$B45,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G45/$B45,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H160[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H45/$B45,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H45/$B45,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I160[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I45/$B45,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I45/$B45,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J160[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J45/$B45,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J45/$B45,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D161[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D46/$B46,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D46/$B46,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E161[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E46/$B46,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E46/$B46,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F161[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F46/$B46,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F46/$B46,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G161[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G46/$B46,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G46/$B46,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H161[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H46/$B46,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H46/$B46,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I161[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I46/$B46,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I46/$B46,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J161[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J46/$B46,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J46/$B46,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D162[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D47/$B47,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D47/$B47,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E162[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E47/$B47,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E47/$B47,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F162[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F47/$B47,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F47/$B47,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G162[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G47/$B47,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G47/$B47,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H162[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H47/$B47,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H47/$B47,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I162[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I47/$B47,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I47/$B47,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J162[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J47/$B47,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J47/$B47,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D163[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D48/$B48,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D48/$B48,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E163[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E48/$B48,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E48/$B48,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F163[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F48/$B48,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F48/$B48,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G163[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G48/$B48,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G48/$B48,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H163[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H48/$B48,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H48/$B48,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I163[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I48/$B48,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I48/$B48,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J163[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J48/$B48,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J48/$B48,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D164[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D49/$B49,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D49/$B49,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E164[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E49/$B49,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E49/$B49,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F164[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F49/$B49,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F49/$B49,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G164[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G49/$B49,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G49/$B49,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H164[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H49/$B49,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H49/$B49,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I164[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I49/$B49,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I49/$B49,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J164[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J49/$B49,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J49/$B49,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D165[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D50/$B50,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D50/$B50,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E165[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E50/$B50,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E50/$B50,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F165[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F50/$B50,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F50/$B50,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G165[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G50/$B50,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G50/$B50,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H165[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H50/$B50,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H50/$B50,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I165[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I50/$B50,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I50/$B50,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J165[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J50/$B50,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J50/$B50,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D166[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D51/$B51,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D51/$B51,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E166[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E51/$B51,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E51/$B51,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F166[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F51/$B51,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F51/$B51,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G166[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G51/$B51,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G51/$B51,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H166[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H51/$B51,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H51/$B51,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I166[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I51/$B51,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I51/$B51,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J166[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J51/$B51,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J51/$B51,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D167[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]D52/$B52,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]D52/$B52,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E167[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]E52/$B52,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]E52/$B52,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]F167[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]F52/$B52,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]F52/$B52,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G167[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]G52/$B52,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]G52/$B52,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H167[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]H52/$B52,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]H52/$B52,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I167[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]I52/$B52,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]I52/$B52,0[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J167[/TH]
[TD]=IF([COLOR=Blue]IFERROR([COLOR=Red]J52/$B52,0[/COLOR])<0.001,"-",IFERROR([COLOR=Red]J52/$B52,0[/COLOR])[/COLOR])[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 
Upvote 0

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Forum statistics

Threads
1,221,417
Messages
6,159,789
Members
451,589
Latest member
Harold14

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top