Hi all,
I am hoping this is an easy get for someone. My brain has shutdown after waaaay too much computer time.
I am trying to show the highest of the high's of the previous week.
In my data each row represents a trading day. I have the current week number in "g" column. I would like to look at the previous weeks days (rows) and show the max of all the high values. It doesn't matter if this max value shows for every row or just once in its column "I" for that current week.
I hope that makes sense.
Cheers,
[B]Excel 2010[/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]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[TH]I[/TH]
[/TR]
</thead><tbody>[TR]
[TD="align: center"]2[/TD]
[TD]date[/TD]
[TD]open [/TD]
[TD]high[/TD]
[TD]low[/TD]
[TD]close[/TD]
[TD]wk[/TD]
[TD]NWK[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: right"]2/01/1992[/TD]
[TD="align: right"]1691[/TD]
[TD="align: right"]1691[/TD]
[TD="align: right"]1670[/TD]
[TD="align: right"]1671[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: right"]3/01/1992[/TD]
[TD="align: right"]1666[/TD]
[TD="align: right"]1691[/TD]
[TD="align: right"]1666[/TD]
[TD="align: right"]1690[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: right"]6/01/1992[/TD]
[TD="align: right"]1703[/TD]
[TD="align: right"]1719[/TD]
[TD="align: right"]1699[/TD]
[TD="align: right"]1704[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: right"]7/01/1992[/TD]
[TD="align: right"]1700[/TD]
[TD="align: right"]1710[/TD]
[TD="align: right"]1695[/TD]
[TD="align: right"]1702[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: right"]8/01/1992[/TD]
[TD="align: right"]1702[/TD]
[TD="align: right"]1705[/TD]
[TD="align: right"]1694[/TD]
[TD="align: right"]1700[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: right"]9/01/1992[/TD]
[TD="align: right"]1699[/TD]
[TD="align: right"]1700[/TD]
[TD="align: right"]1692[/TD]
[TD="align: right"]1692[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: right"]10/01/1992[/TD]
[TD="align: right"]1702[/TD]
[TD="align: right"]1702[/TD]
[TD="align: right"]1689[/TD]
[TD="align: right"]1691[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: right"]13/01/1992[/TD]
[TD="align: right"]1690[/TD]
[TD="align: right"]1700[/TD]
[TD="align: right"]1683[/TD]
[TD="align: right"]1688[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: right"]14/01/1992[/TD]
[TD="align: right"]1683[/TD]
[TD="align: right"]1687[/TD]
[TD="align: right"]1677[/TD]
[TD="align: right"]1677[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: right"]15/01/1992[/TD]
[TD="align: right"]1698[/TD]
[TD="align: right"]1709[/TD]
[TD="align: right"]1694[/TD]
[TD="align: right"]1700[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: right"]16/01/1992[/TD]
[TD="align: right"]1705[/TD]
[TD="align: right"]1707[/TD]
[TD="align: right"]1692[/TD]
[TD="align: right"]1692[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: right"]17/01/1992[/TD]
[TD="align: right"]1689[/TD]
[TD="align: right"]1693[/TD]
[TD="align: right"]1685[/TD]
[TD="align: right"]1692[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: right"]20/01/1992[/TD]
[TD="align: right"]1694[/TD]
[TD="align: right"]1704[/TD]
[TD="align: right"]1683[/TD]
[TD="align: right"]1683[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: right"]21/01/1992[/TD]
[TD="align: right"]1678[/TD]
[TD="align: right"]1682[/TD]
[TD="align: right"]1656[/TD]
[TD="align: right"]1656[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: right"]22/01/1992[/TD]
[TD="align: right"]1640[/TD]
[TD="align: right"]1657[/TD]
[TD="align: right"]1637[/TD]
[TD="align: right"]1655[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: right"]23/01/1992[/TD]
[TD="align: right"]1662[/TD]
[TD="align: right"]1665[/TD]
[TD="align: right"]1651[/TD]
[TD="align: right"]1654[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="align: right"]24/01/1992[/TD]
[TD="align: right"]1636[/TD]
[TD="align: right"]1645[/TD]
[TD="align: right"]1623[/TD]
[TD="align: right"]1635[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: right"]28/01/1992[/TD]
[TD="align: right"]1635[/TD]
[TD="align: right"]1646[/TD]
[TD="align: right"]1628[/TD]
[TD="align: right"]1646[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD="align: right"]29/01/1992[/TD]
[TD="align: right"]1655[/TD]
[TD="align: right"]1658[/TD]
[TD="align: right"]1632[/TD]
[TD="align: right"]1650[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD="align: right"]30/01/1992[/TD]
[TD="align: right"]1628[/TD]
[TD="align: right"]1638[/TD]
[TD="align: right"]1621[/TD]
[TD="align: right"]1638[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]23[/TD]
[TD="align: right"]31/01/1992[/TD]
[TD="align: right"]1640[/TD]
[TD="align: right"]1645[/TD]
[TD="align: right"]1638[/TD]
[TD="align: right"]1639[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD="align: right"]3/02/1992[/TD]
[TD="align: right"]1632[/TD]
[TD="align: right"]1642[/TD]
[TD="align: right"]1625[/TD]
[TD="align: right"]1626[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD="align: right"]4/02/1992[/TD]
[TD="align: right"]1623[/TD]
[TD="align: right"]1623[/TD]
[TD="align: right"]1602[/TD]
[TD="align: right"]1614[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD="align: right"]5/02/1992[/TD]
[TD="align: right"]1623[/TD]
[TD="align: right"]1623[/TD]
[TD="align: right"]1605[/TD]
[TD="align: right"]1607[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[CENTER][COLOR=#161120][B]SPI_HISTORICAL IAR test[/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] "]G3[/TH]
[TD]=WEEKNUM([COLOR=Blue]B3,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G4[/TH]
[TD]=WEEKNUM([COLOR=Blue]B4,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G5[/TH]
[TD]=WEEKNUM([COLOR=Blue]B5,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G6[/TH]
[TD]=WEEKNUM([COLOR=Blue]B6,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G7[/TH]
[TD]=WEEKNUM([COLOR=Blue]B7,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G8[/TH]
[TD]=WEEKNUM([COLOR=Blue]B8,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G9[/TH]
[TD]=WEEKNUM([COLOR=Blue]B9,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G10[/TH]
[TD]=WEEKNUM([COLOR=Blue]B10,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G11[/TH]
[TD]=WEEKNUM([COLOR=Blue]B11,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G12[/TH]
[TD]=WEEKNUM([COLOR=Blue]B12,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G13[/TH]
[TD]=WEEKNUM([COLOR=Blue]B13,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G14[/TH]
[TD]=WEEKNUM([COLOR=Blue]B14,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G15[/TH]
[TD]=WEEKNUM([COLOR=Blue]B15,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G16[/TH]
[TD]=WEEKNUM([COLOR=Blue]B16,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G17[/TH]
[TD]=WEEKNUM([COLOR=Blue]B17,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G18[/TH]
[TD]=WEEKNUM([COLOR=Blue]B18,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G19[/TH]
[TD]=WEEKNUM([COLOR=Blue]B19,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G20[/TH]
[TD]=WEEKNUM([COLOR=Blue]B20,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G21[/TH]
[TD]=WEEKNUM([COLOR=Blue]B21,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G22[/TH]
[TD]=WEEKNUM([COLOR=Blue]B22,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G23[/TH]
[TD]=WEEKNUM([COLOR=Blue]B23,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G24[/TH]
[TD]=WEEKNUM([COLOR=Blue]B24,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G25[/TH]
[TD]=WEEKNUM([COLOR=Blue]B25,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G26[/TH]
[TD]=WEEKNUM([COLOR=Blue]B26,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H10[/TH]
[TD]=IF([COLOR=Blue]G10=G9,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H11[/TH]
[TD]=IF([COLOR=Blue]G11=G10,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H12[/TH]
[TD]=IF([COLOR=Blue]G12=G11,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H13[/TH]
[TD]=IF([COLOR=Blue]G13=G12,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H14[/TH]
[TD]=IF([COLOR=Blue]G14=G13,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H15[/TH]
[TD]=IF([COLOR=Blue]G15=G14,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H16[/TH]
[TD]=IF([COLOR=Blue]G16=G15,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H17[/TH]
[TD]=IF([COLOR=Blue]G17=G16,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H18[/TH]
[TD]=IF([COLOR=Blue]G18=G17,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H19[/TH]
[TD]=IF([COLOR=Blue]G19=G18,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H20[/TH]
[TD]=IF([COLOR=Blue]G20=G19,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H21[/TH]
[TD]=IF([COLOR=Blue]G21=G20,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H22[/TH]
[TD]=IF([COLOR=Blue]G22=G21,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H23[/TH]
[TD]=IF([COLOR=Blue]G23=G22,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H24[/TH]
[TD]=IF([COLOR=Blue]G24=G23,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H25[/TH]
[TD]=IF([COLOR=Blue]G25=G24,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H26[/TH]
[TD]=IF([COLOR=Blue]G26=G25,0,1[/COLOR])[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I am hoping this is an easy get for someone. My brain has shutdown after waaaay too much computer time.
I am trying to show the highest of the high's of the previous week.
In my data each row represents a trading day. I have the current week number in "g" column. I would like to look at the previous weeks days (rows) and show the max of all the high values. It doesn't matter if this max value shows for every row or just once in its column "I" for that current week.
I hope that makes sense.
Cheers,
[B]Excel 2010[/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]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[TH]I[/TH]
[/TR]
</thead><tbody>[TR]
[TD="align: center"]2[/TD]
[TD]date[/TD]
[TD]open [/TD]
[TD]high[/TD]
[TD]low[/TD]
[TD]close[/TD]
[TD]wk[/TD]
[TD]NWK[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: right"]2/01/1992[/TD]
[TD="align: right"]1691[/TD]
[TD="align: right"]1691[/TD]
[TD="align: right"]1670[/TD]
[TD="align: right"]1671[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: right"]3/01/1992[/TD]
[TD="align: right"]1666[/TD]
[TD="align: right"]1691[/TD]
[TD="align: right"]1666[/TD]
[TD="align: right"]1690[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: right"]6/01/1992[/TD]
[TD="align: right"]1703[/TD]
[TD="align: right"]1719[/TD]
[TD="align: right"]1699[/TD]
[TD="align: right"]1704[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: right"]7/01/1992[/TD]
[TD="align: right"]1700[/TD]
[TD="align: right"]1710[/TD]
[TD="align: right"]1695[/TD]
[TD="align: right"]1702[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: right"]8/01/1992[/TD]
[TD="align: right"]1702[/TD]
[TD="align: right"]1705[/TD]
[TD="align: right"]1694[/TD]
[TD="align: right"]1700[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: right"]9/01/1992[/TD]
[TD="align: right"]1699[/TD]
[TD="align: right"]1700[/TD]
[TD="align: right"]1692[/TD]
[TD="align: right"]1692[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: right"]10/01/1992[/TD]
[TD="align: right"]1702[/TD]
[TD="align: right"]1702[/TD]
[TD="align: right"]1689[/TD]
[TD="align: right"]1691[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: right"]13/01/1992[/TD]
[TD="align: right"]1690[/TD]
[TD="align: right"]1700[/TD]
[TD="align: right"]1683[/TD]
[TD="align: right"]1688[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: right"]14/01/1992[/TD]
[TD="align: right"]1683[/TD]
[TD="align: right"]1687[/TD]
[TD="align: right"]1677[/TD]
[TD="align: right"]1677[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: right"]15/01/1992[/TD]
[TD="align: right"]1698[/TD]
[TD="align: right"]1709[/TD]
[TD="align: right"]1694[/TD]
[TD="align: right"]1700[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: right"]16/01/1992[/TD]
[TD="align: right"]1705[/TD]
[TD="align: right"]1707[/TD]
[TD="align: right"]1692[/TD]
[TD="align: right"]1692[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: right"]17/01/1992[/TD]
[TD="align: right"]1689[/TD]
[TD="align: right"]1693[/TD]
[TD="align: right"]1685[/TD]
[TD="align: right"]1692[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: right"]20/01/1992[/TD]
[TD="align: right"]1694[/TD]
[TD="align: right"]1704[/TD]
[TD="align: right"]1683[/TD]
[TD="align: right"]1683[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: right"]21/01/1992[/TD]
[TD="align: right"]1678[/TD]
[TD="align: right"]1682[/TD]
[TD="align: right"]1656[/TD]
[TD="align: right"]1656[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: right"]22/01/1992[/TD]
[TD="align: right"]1640[/TD]
[TD="align: right"]1657[/TD]
[TD="align: right"]1637[/TD]
[TD="align: right"]1655[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: right"]23/01/1992[/TD]
[TD="align: right"]1662[/TD]
[TD="align: right"]1665[/TD]
[TD="align: right"]1651[/TD]
[TD="align: right"]1654[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="align: right"]24/01/1992[/TD]
[TD="align: right"]1636[/TD]
[TD="align: right"]1645[/TD]
[TD="align: right"]1623[/TD]
[TD="align: right"]1635[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: right"]28/01/1992[/TD]
[TD="align: right"]1635[/TD]
[TD="align: right"]1646[/TD]
[TD="align: right"]1628[/TD]
[TD="align: right"]1646[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD="align: right"]29/01/1992[/TD]
[TD="align: right"]1655[/TD]
[TD="align: right"]1658[/TD]
[TD="align: right"]1632[/TD]
[TD="align: right"]1650[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD="align: right"]30/01/1992[/TD]
[TD="align: right"]1628[/TD]
[TD="align: right"]1638[/TD]
[TD="align: right"]1621[/TD]
[TD="align: right"]1638[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]23[/TD]
[TD="align: right"]31/01/1992[/TD]
[TD="align: right"]1640[/TD]
[TD="align: right"]1645[/TD]
[TD="align: right"]1638[/TD]
[TD="align: right"]1639[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD="align: right"]3/02/1992[/TD]
[TD="align: right"]1632[/TD]
[TD="align: right"]1642[/TD]
[TD="align: right"]1625[/TD]
[TD="align: right"]1626[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD="align: right"]4/02/1992[/TD]
[TD="align: right"]1623[/TD]
[TD="align: right"]1623[/TD]
[TD="align: right"]1602[/TD]
[TD="align: right"]1614[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD="align: right"]5/02/1992[/TD]
[TD="align: right"]1623[/TD]
[TD="align: right"]1623[/TD]
[TD="align: right"]1605[/TD]
[TD="align: right"]1607[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[CENTER][COLOR=#161120][B]SPI_HISTORICAL IAR test[/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] "]G3[/TH]
[TD]=WEEKNUM([COLOR=Blue]B3,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G4[/TH]
[TD]=WEEKNUM([COLOR=Blue]B4,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G5[/TH]
[TD]=WEEKNUM([COLOR=Blue]B5,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G6[/TH]
[TD]=WEEKNUM([COLOR=Blue]B6,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G7[/TH]
[TD]=WEEKNUM([COLOR=Blue]B7,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G8[/TH]
[TD]=WEEKNUM([COLOR=Blue]B8,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G9[/TH]
[TD]=WEEKNUM([COLOR=Blue]B9,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G10[/TH]
[TD]=WEEKNUM([COLOR=Blue]B10,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G11[/TH]
[TD]=WEEKNUM([COLOR=Blue]B11,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G12[/TH]
[TD]=WEEKNUM([COLOR=Blue]B12,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G13[/TH]
[TD]=WEEKNUM([COLOR=Blue]B13,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G14[/TH]
[TD]=WEEKNUM([COLOR=Blue]B14,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G15[/TH]
[TD]=WEEKNUM([COLOR=Blue]B15,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G16[/TH]
[TD]=WEEKNUM([COLOR=Blue]B16,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G17[/TH]
[TD]=WEEKNUM([COLOR=Blue]B17,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G18[/TH]
[TD]=WEEKNUM([COLOR=Blue]B18,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G19[/TH]
[TD]=WEEKNUM([COLOR=Blue]B19,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G20[/TH]
[TD]=WEEKNUM([COLOR=Blue]B20,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G21[/TH]
[TD]=WEEKNUM([COLOR=Blue]B21,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G22[/TH]
[TD]=WEEKNUM([COLOR=Blue]B22,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G23[/TH]
[TD]=WEEKNUM([COLOR=Blue]B23,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G24[/TH]
[TD]=WEEKNUM([COLOR=Blue]B24,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G25[/TH]
[TD]=WEEKNUM([COLOR=Blue]B25,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G26[/TH]
[TD]=WEEKNUM([COLOR=Blue]B26,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H10[/TH]
[TD]=IF([COLOR=Blue]G10=G9,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H11[/TH]
[TD]=IF([COLOR=Blue]G11=G10,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H12[/TH]
[TD]=IF([COLOR=Blue]G12=G11,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H13[/TH]
[TD]=IF([COLOR=Blue]G13=G12,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H14[/TH]
[TD]=IF([COLOR=Blue]G14=G13,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H15[/TH]
[TD]=IF([COLOR=Blue]G15=G14,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H16[/TH]
[TD]=IF([COLOR=Blue]G16=G15,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H17[/TH]
[TD]=IF([COLOR=Blue]G17=G16,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H18[/TH]
[TD]=IF([COLOR=Blue]G18=G17,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H19[/TH]
[TD]=IF([COLOR=Blue]G19=G18,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H20[/TH]
[TD]=IF([COLOR=Blue]G20=G19,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H21[/TH]
[TD]=IF([COLOR=Blue]G21=G20,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H22[/TH]
[TD]=IF([COLOR=Blue]G22=G21,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H23[/TH]
[TD]=IF([COLOR=Blue]G23=G22,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H24[/TH]
[TD]=IF([COLOR=Blue]G24=G23,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H25[/TH]
[TD]=IF([COLOR=Blue]G25=G24,0,1[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H26[/TH]
[TD]=IF([COLOR=Blue]G26=G25,0,1[/COLOR])[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]