Rebasing HELP!

A

Afro15

New Member
Joined
Jun 5, 2015
Messages
3
I have two data sets to be compared, I need to rebase them so that they are comparable and plot-able. Unfortunately for me I am awful with Excel. Could anyone PLEASE help?

Thanks so much in advance



[TABLE="width: 346"]
<tbody>[TR]
[TD="align: right"]04/06/2015[/TD]
[TD="align: right"]74.5[/TD]
[TD][/TD]
[TD="align: right"]777.29999[/TD]
[/TR]
[TR]
[TD="align: right"]03/06/2015[/TD]
[TD="align: right"]80.5[/TD]
[TD][/TD]
[TD="align: right"]778.09998[/TD]
[/TR]
[TR]
[TD="align: right"]02/06/2015[/TD]
[TD="align: right"]82.5[/TD]
[TD][/TD]
[TD="align: right"]775.40002[/TD]
[/TR]
[TR]
[TD="align: right"]01/06/2015[/TD]
[TD="align: right"]86[/TD]
[TD][/TD]
[TD="align: right"]775.79999[/TD]
[/TR]
[TR]
[TD="align: right"]29/05/2015[/TD]
[TD="align: right"]86.5[/TD]
[TD][/TD]
[TD="align: right"]772.59998[/TD]
[/TR]
[TR]
[TD="align: right"]28/05/2015[/TD]
[TD="align: right"]87.5[/TD]
[TD][/TD]
[TD="align: right"]770.29999[/TD]
[/TR]
[TR]
[TD="align: right"]27/05/2015[/TD]
[TD="align: right"]88.5[/TD]
[TD][/TD]
[TD="align: right"]765.90002[/TD]
[/TR]
[TR]
[TD="align: right"]26/05/2015[/TD]
[TD="align: right"]85[/TD]
[TD][/TD]
[TD="align: right"]764.90002[/TD]
[/TR]
[TR]
[TD="align: right"]25/05/2015[/TD]
[TD="align: right"]85.5[/TD]
[TD][/TD]
[TD="align: right"]766.70001[/TD]
[/TR]
[TR]
[TD="align: right"]22/05/2015[/TD]
[TD="align: right"]85.5[/TD]
[TD][/TD]
[TD="align: right"]763.70001[/TD]
[/TR]
[TR]
[TD="align: right"]21/05/2015[/TD]
[TD="align: right"]84.5[/TD]
[TD][/TD]
[TD="align: right"]762.59998[/TD]
[/TR]
[TR]
[TD="align: right"]20/05/2015[/TD]
[TD="align: right"]84.5[/TD]
[TD][/TD]
[TD="align: right"]762.40002[/TD]
[/TR]
[TR]
[TD="align: right"]19/05/2015[/TD]
[TD="align: right"]87[/TD]
[TD][/TD]
[TD="align: right"]760[/TD]
[/TR]
[TR]
[TD="align: right"]18/05/2015[/TD]
[TD="align: right"]85[/TD]
[TD][/TD]
[TD="align: right"]762[/TD]
[/TR]
[TR]
[TD="align: right"]15/05/2015[/TD]
[TD="align: right"]88.75[/TD]
[TD][/TD]
[TD="align: right"]759.5[/TD]
[/TR]
[TR]
[TD="align: right"]14/05/2015[/TD]
[TD="align: right"]90.75[/TD]
[TD][/TD]
[TD="align: right"]759.90002[/TD]
[/TR]
[TR]
[TD="align: right"]13/05/2015[/TD]
[TD="align: right"]90[/TD]
[TD][/TD]
[TD="align: right"]756.90002[/TD]
[/TR]
[TR]
[TD="align: right"]12/05/2015[/TD]
[TD="align: right"]91[/TD]
[TD][/TD]
[TD="align: right"]759.20001[/TD]
[/TR]
[TR]
[TD="align: right"]11/05/2015[/TD]
[TD="align: right"]88[/TD]
[TD][/TD]
[TD="align: right"]753.29999[/TD]
[/TR]
[TR]
[TD="align: right"]08/05/2015[/TD]
[TD="align: right"]90.5[/TD]
[TD][/TD]
[TD="align: right"]748.59998[/TD]
[/TR]
[TR]
[TD="align: right"]07/05/2015[/TD]
[TD="align: right"]92.25[/TD]
[TD][/TD]
[TD="align: right"]751.59998[/TD]
[/TR]
[TR]
[TD="align: right"]06/05/2015[/TD]
[TD="align: right"]95[/TD]
[TD][/TD]
[TD="align: right"]751.70001[/TD]
[/TR]
[TR]
[TD="align: right"]05/05/2015[/TD]
[TD="align: right"]94[/TD]
[TD][/TD]
[TD="align: right"]753[/TD]
[/TR]
[TR]
[TD="align: right"]04/05/2015[/TD]
[TD="align: right"]99[/TD]
[TD][/TD]
[TD="align: right"]753.29999[/TD]
[/TR]
[TR]
[TD="align: right"]01/05/2015[/TD]
[TD="align: right"]99[/TD]
[TD][/TD]
[TD="align: right"]752.40002[/TD]
[/TR]
[TR]
[TD="align: right"]30/04/2015[/TD]
[TD="align: right"]97[/TD]
[TD][/TD]
[TD="align: right"]753.90002[/TD]
[/TR]
[TR]
[TD="align: right"]29/04/2015[/TD]
[TD="align: right"]96.75[/TD]
[TD][/TD]
[TD="align: right"]755.59998[/TD]
[/TR]
[TR]
[TD="align: right"]28/04/2015[/TD]
[TD="align: right"]97.625[/TD]
[TD][/TD]
[TD="align: right"]753.40002[/TD]
[/TR]
[TR]
[TD="align: right"]27/04/2015[/TD]
[TD="align: right"]93.75[/TD]
[TD][/TD]
[TD="align: right"]751[/TD]
[/TR]
[TR]
[TD="align: right"]24/04/2015[/TD]
[TD="align: right"]90.5[/TD]
[TD][/TD]
[TD="align: right"]749.70001[/TD]
[/TR]
[TR]
[TD="align: right"]23/04/2015[/TD]
[TD="align: right"]90[/TD]
[TD][/TD]
[TD="align: right"]750.90002[/TD]
[/TR]
[TR]
[TD="align: right"]22/04/2015[/TD]
[TD="align: right"]85[/TD]
[TD][/TD]
[TD="align: right"]749.09998[/TD]
[/TR]
[TR]
[TD="align: right"]21/04/2015[/TD]
[TD="align: right"]86.5[/TD]
[TD][/TD]
[TD="align: right"]749.70001[/TD]
[/TR]
[TR]
[TD="align: right"]20/04/2015[/TD]
[TD="align: right"]84[/TD]
[TD][/TD]
[TD="align: right"]749.20001[/TD]
[/TR]
[TR]
[TD="align: right"]17/04/2015[/TD]
[TD="align: right"]82.5[/TD]
[TD][/TD]
[TD="align: right"]746.5[/TD]
[/TR]
[TR]
[TD="align: right"]16/04/2015[/TD]
[TD="align: right"]87[/TD]
[TD][/TD]
[TD="align: right"]741.79999[/TD]
[/TR]
[TR]
[TD="align: right"]15/04/2015[/TD]
[TD="align: right"]88[/TD]
[TD][/TD]
[TD="align: right"]739[/TD]
[/TR]
[TR]
[TD="align: right"]14/04/2015[/TD]
[TD="align: right"]90[/TD]
[TD][/TD]
[TD="align: right"]735.70001[/TD]
[/TR]
[TR]
[TD="align: right"]13/04/2015[/TD]
[TD="align: right"]90.5[/TD]
[TD][/TD]
[TD="align: right"]732.40002[/TD]
[/TR]
[TR]
[TD="align: right"]10/04/2015[/TD]
[TD="align: right"]87.5[/TD]
[TD][/TD]
[TD="align: right"]725.5[/TD]
[/TR]
[TR]
[TD="align: right"]09/04/2015[/TD]
[TD="align: right"]86.5[/TD]
[TD][/TD]
[TD="align: right"]722.40002[/TD]
[/TR]
[TR]
[TD="align: right"]08/04/2015[/TD]
[TD="align: right"]91.5[/TD]
[TD][/TD]
[TD="align: right"]715.29999[/TD]
[/TR]
[TR]
[TD="align: right"]07/04/2015[/TD]
[TD="align: right"]85.5[/TD]
[TD][/TD]
[TD="align: right"]715.29999[/TD]
[/TR]
[TR]
[TD="align: right"]06/04/2015[/TD]
[TD="align: right"]87.5[/TD]
[TD][/TD]
[TD="align: right"]716.20001[/TD]
[/TR]
[TR]
[TD="align: right"]03/04/2015[/TD]
[TD="align: right"]87.5[/TD]
[TD][/TD]
[TD="align: right"]719.70001[/TD]
[/TR]
[TR]
[TD="align: right"]02/04/2015[/TD]
[TD="align: right"]87.5[/TD]
[TD][/TD]
[TD="align: right"]717.59998[/TD]
[/TR]
[TR]
[TD="align: right"]01/04/2015[/TD]
[TD="align: right"]77.5[/TD]
[TD][/TD]
[TD="align: right"]716.90002[/TD]
[/TR]
[TR]
[TD="align: right"]31/03/2015[/TD]
[TD="align: right"]74.5[/TD]
[TD][/TD]
[TD="align: right"]717.40002[/TD]
[/TR]
[TR]
[TD="align: right"]30/03/2015[/TD]
[TD="align: right"]72.75[/TD]
[TD][/TD]
[TD="align: right"]721.59998[/TD]
[/TR]
[TR]
[TD="align: right"]27/03/2015[/TD]
[TD="align: right"]71.5[/TD]
[TD][/TD]
[TD="align: right"]716.20001[/TD]
[/TR]
[TR]
[TD="align: right"]26/03/2015[/TD]
[TD="align: right"]67[/TD]
[TD][/TD]
[TD="align: right"]715.90002[/TD]
[/TR]
[TR]
[TD="align: right"]25/03/2015[/TD]
[TD="align: right"]67[/TD]
[TD][/TD]
[TD="align: right"]715.29999[/TD]
[/TR]
[TR]
[TD="align: right"]24/03/2015[/TD]
[TD="align: right"]64.5[/TD]
[TD][/TD]
[TD="align: right"]715.5[/TD]
[/TR]
[TR]
[TD="align: right"]23/03/2015[/TD]
[TD="align: right"]62[/TD]
[TD][/TD]
[TD="align: right"]715.59998[/TD]
[/TR]
[TR]
[TD="align: right"]20/03/2015[/TD]
[TD="align: right"]63[/TD]
[TD][/TD]
[TD="align: right"]715.90002[/TD]
[/TR]
[TR]
[TD="align: right"]19/03/2015[/TD]
[TD="align: right"]64.5[/TD]
[TD][/TD]
[TD="align: right"]717.79999[/TD]
[/TR]
[TR]
[TD="align: right"]18/03/2015[/TD]
[TD="align: right"]66[/TD]
[TD][/TD]
[TD="align: right"]716.20001[/TD]
[/TR]
[TR]
[TD="align: right"]17/03/2015[/TD]
[TD="align: right"]68.75[/TD]
[TD][/TD]
[TD="align: right"]711.59998[/TD]
[/TR]
[TR]
[TD="align: right"]16/03/2015[/TD]
[TD="align: right"]70.25[/TD]
[TD][/TD]
[TD="align: right"]711.59998[/TD]
[/TR]
[TR]
[TD="align: right"]13/03/2015[/TD]
[TD="align: right"]70.25[/TD]
[TD][/TD]
[TD="align: right"]715.90002[/TD]
[/TR]
[TR]
[TD="align: right"]12/03/2015[/TD]
[TD="align: right"]68.5[/TD]
[TD][/TD]
[TD="align: right"]718.09998[/TD]
[/TR]
[TR]
[TD="align: right"]11/03/2015[/TD]
[TD="align: right"]70.5[/TD]
[TD][/TD]
[TD="align: right"]714.09998[/TD]
[/TR]
[TR]
[TD="align: right"]10/03/2015[/TD]
[TD="align: right"]72[/TD]
[TD][/TD]
[TD="align: right"]712.20001[/TD]
[/TR]
[TR]
[TD="align: right"]09/03/2015[/TD]
[TD="align: right"]68[/TD]
[TD][/TD]
[TD="align: right"]709.20001[/TD]
[/TR]
[TR]
[TD="align: right"]06/03/2015[/TD]
[TD="align: right"]69.5[/TD]
[TD][/TD]
[TD="align: right"]713.09998[/TD]
[/TR]
[TR]
[TD="align: right"]05/03/2015[/TD]
[TD="align: right"]71[/TD]
[TD][/TD]
[TD="align: right"]714.5[/TD]
[/TR]
[TR]
[TD="align: right"]04/03/2015[/TD]
[TD="align: right"]71[/TD]
[TD][/TD]
[TD="align: right"]712.79999[/TD]
[/TR]
[TR]
[TD="align: right"]03/03/2015[/TD]
[TD="align: right"]75.5[/TD]
[TD][/TD]
[TD="align: right"]709.5[/TD]
[/TR]
[TR]
[TD="align: right"]02/03/2015[/TD]
[TD="align: right"]73.25[/TD]
[TD][/TD]
[TD="align: right"]711.59998[/TD]
[/TR]
[TR]
[TD="align: right"]27/02/2015[/TD]
[TD="align: right"]64.5[/TD]
[TD][/TD]
[TD="align: right"]713.09998[/TD]
[/TR]
[TR]
[TD="align: right"]26/02/2015[/TD]
[TD="align: right"]59.5[/TD]
[TD][/TD]
[TD="align: right"]711.20001[/TD]
[/TR]
[TR]
[TD="align: right"]25/02/2015[/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[TD="align: right"]709.5[/TD]
[/TR]
[TR]
[TD="align: right"]24/02/2015[/TD]
[TD="align: right"]61[/TD]
[TD][/TD]
[TD="align: right"]708.59998[/TD]
[/TR]
[TR]
[TD="align: right"]23/02/2015[/TD]
[TD="align: right"]64.5[/TD]
[TD][/TD]
[TD="align: right"]706.70001[/TD]
[/TR]
[TR]
[TD="align: right"]20/02/2015[/TD]
[TD="align: right"]64[/TD]
[TD][/TD]
[TD="align: right"]703.20001[/TD]
[/TR]
[TR]
[TD="align: right"]19/02/2015[/TD]
[TD="align: right"]68.5[/TD]
[TD][/TD]
[TD="align: right"]700.20001[/TD]
[/TR]
[TR]
[TD="align: right"]18/02/2015[/TD]
[TD="align: right"]65[/TD]
[TD][/TD]
[TD="align: right"]698.09998[/TD]
[/TR]
[TR]
[TD="align: right"]17/02/2015[/TD]
[TD="align: right"]59[/TD]
[TD][/TD]
[TD="align: right"]696.90002[/TD]
[/TR]
[TR]
[TD="align: right"]16/02/2015[/TD]
[TD="align: right"]56[/TD]
[TD][/TD]
[TD="align: right"]700[/TD]
[/TR]
[TR]
[TD="align: right"]13/02/2015[/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[TD="align: right"]699.20001[/TD]
[/TR]
[TR]
[TD="align: right"]12/02/2015[/TD]
[TD="align: right"]52.5[/TD]
[TD][/TD]
[TD="align: right"]700.5[/TD]
[/TR]
[TR]
[TD="align: right"]11/02/2015[/TD]
[TD="align: right"]41.5[/TD]
[TD][/TD]
[TD="align: right"]698[/TD]
[/TR]
[TR]
[TD="align: right"]10/02/2015[/TD]
[TD="align: right"]41.5[/TD]
[TD][/TD]
[TD="align: right"]720.90002[/TD]
[/TR]
[TR]
[TD="align: right"]09/02/2015[/TD]
[TD="align: right"]42.5[/TD]
[TD][/TD]
[TD="align: right"]712.70001[/TD]
[/TR]
[TR]
[TD="align: right"]06/02/2015[/TD]
[TD="align: right"]42.5[/TD]
[TD][/TD]
[TD="align: right"]713.79999[/TD]
[/TR]
[TR]
[TD="align: right"]05/02/2015[/TD]
[TD="align: right"]44[/TD]
[TD][/TD]
[TD="align: right"]716.20001[/TD]
[/TR]
[TR]
[TD="align: right"]04/02/2015[/TD]
[TD="align: right"]45[/TD]
[TD][/TD]
[TD="align: right"]712[/TD]
[/TR]
[TR]
[TD="align: right"]03/02/2015[/TD]
[TD="align: right"]45.5[/TD]
[TD][/TD]
[TD="align: right"]720.20001[/TD]
[/TR]
[TR]
[TD="align: right"]02/02/2015[/TD]
[TD="align: right"]47.5[/TD]
[TD][/TD]
[TD="align: right"]717.40002[/TD]
[/TR]
[TR]
[TD="align: right"]30/01/2015[/TD]
[TD="align: right"]47.5[/TD]
[TD][/TD]
[TD="align: right"]723.5[/TD]
[/TR]
[TR]
[TD="align: right"]29/01/2015[/TD]
[TD="align: right"]47.5[/TD]
[TD][/TD]
[TD="align: right"]722.90002[/TD]
[/TR]
[TR]
[TD="align: right"]28/01/2015[/TD]
[TD="align: right"]48.5[/TD]
[TD][/TD]
[TD="align: right"]715.40002[/TD]
[/TR]
[TR]
[TD="align: right"]27/01/2015[/TD]
[TD="align: right"]49[/TD]
[TD][/TD]
[TD="align: right"]711.20001[/TD]
[/TR]
[TR]
[TD="align: right"]26/01/2015[/TD]
[TD="align: right"]49[/TD]
[TD][/TD]
[TD="align: right"]714.59998[/TD]
[/TR]
[TR]
[TD="align: right"]23/01/2015[/TD]
[TD="align: right"]49[/TD]
[TD][/TD]
[TD="align: right"]708.5[/TD]
[/TR]
[TR]
[TD="align: right"]22/01/2015[/TD]
[TD="align: right"]48.375[/TD]
[TD][/TD]
[TD="align: right"]712.5[/TD]
[/TR]
[TR]
[TD="align: right"]21/01/2015[/TD]
[TD="align: right"]50.75[/TD]
[TD][/TD]
[TD="align: right"]711.20001[/TD]
[/TR]
[TR]
[TD="align: right"]20/01/2015[/TD]
[TD="align: right"]52.5[/TD]
[TD][/TD]
[TD="align: right"]700.79999[/TD]
[/TR]
[TR]
[TD="align: right"]19/01/2015[/TD]
[TD="align: right"]52.5[/TD]
[TD][/TD]
[TD="align: right"]704.59998[/TD]
[/TR]
[TR]
[TD="align: right"]16/01/2015[/TD]
[TD="align: right"]53[/TD]
[TD][/TD]
[TD="align: right"]703.20001[/TD]
[/TR]
[TR]
[TD="align: right"]15/01/2015[/TD]
[TD="align: right"]53[/TD]
[TD][/TD]
[TD="align: right"]702.29999[/TD]
[/TR]
[TR]
[TD="align: right"]14/01/2015[/TD]
[TD="align: right"]52[/TD]
[TD][/TD]
[TD="align: right"]698.59998[/TD]
[/TR]
[TR]
[TD="align: right"]13/01/2015[/TD]
[TD="align: right"]52.5[/TD]
[TD][/TD]
[TD="align: right"]690.20001[/TD]
[/TR]
[TR]
[TD="align: right"]12/01/2015[/TD]
[TD="align: right"]52[/TD]
[TD][/TD]
[TD="align: right"]694.29999[/TD]
[/TR]
[TR]
[TD="align: right"]09/01/2015[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD="align: right"]701.5[/TD]
[/TR]
[TR]
[TD="align: right"]08/01/2015[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD="align: right"]705[/TD]
[/TR]
[TR]
[TD="align: right"]07/01/2015[/TD]
[TD="align: right"]51[/TD]
[TD][/TD]
[TD="align: right"]702.70001[/TD]
[/TR]
[TR]
[TD="align: right"]06/01/2015[/TD]
[TD="align: right"]49.5[/TD]
[TD][/TD]
[TD="align: right"]696.5[/TD]
[/TR]
[TR]
[TD="align: right"]05/01/2015[/TD]
[TD="align: right"]50.5[/TD]
[TD][/TD]
[TD="align: right"]695.20001[/TD]
[/TR]
[TR]
[TD="align: right"]02/01/2015[/TD]
[TD="align: right"]52.5[/TD]
[TD][/TD]
[TD="align: right"]691.70001[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/2015[/TD]
[TD="align: right"]46[/TD]
[TD][/TD]
[TD="align: right"]691.5[/TD]
[/TR]
[TR]
[TD="align: right"]31/12/2014[/TD]
[TD="align: right"]46[/TD]
[TD][/TD]
[TD="align: right"]692.20001[/TD]
[/TR]
[TR]
[TD="align: right"]30/12/2014[/TD]
[TD="align: right"]44.5[/TD]
[TD][/TD]
[TD="align: right"]688.70001[/TD]
[/TR]
[TR]
[TD="align: right"]29/12/2014[/TD]
[TD="align: right"]43.5[/TD]
[TD][/TD]
[TD="align: right"]684.70001[/TD]
[/TR]
[TR]
[TD="align: right"]26/12/2014[/TD]
[TD="align: right"]44.5[/TD]
[TD][/TD]
[TD="align: right"]669[/TD]
[/TR]
[TR]
[TD="align: right"]25/12/2014[/TD]
[TD="align: right"]44.5[/TD]
[TD][/TD]
[TD="align: right"]667.09998[/TD]
[/TR]
[TR]
[TD="align: right"]24/12/2014[/TD]
[TD="align: right"]44.5[/TD]
[TD][/TD]
[TD="align: right"]671.40002[/TD]
[/TR]
[TR]
[TD="align: right"]23/12/2014[/TD]
[TD="align: right"]47[/TD]
[TD][/TD]
[TD="align: right"]681.20001[/TD]
[/TR]
[TR]
[TD="align: right"]22/12/2014[/TD]
[TD="align: right"]47.75[/TD]
[TD][/TD]
[TD="align: right"]689.5[/TD]
[/TR]
[TR]
[TD="align: right"]19/12/2014[/TD]
[TD="align: right"]47[/TD]
[TD][/TD]
[TD="align: right"]692.90002[/TD]
[/TR]
[TR]
[TD="align: right"]18/12/2014[/TD]
[TD="align: right"]41[/TD]
[TD][/TD]
[TD="align: right"]706.90002[/TD]
[/TR]
[TR]
[TD="align: right"]17/12/2014[/TD]
[TD="align: right"]38.5[/TD]
[TD][/TD]
[TD="align: right"]713.40002[/TD]
[/TR]
[TR]
[TD="align: right"]16/12/2014[/TD]
[TD="align: right"]34.5[/TD]
[TD][/TD]
[TD="align: right"]714.09998[/TD]
[/TR]
[TR]
[TD="align: right"]15/12/2014[/TD]
[TD="align: right"]35[/TD]
[TD][/TD]
[TD="align: right"]710.20001[/TD]
[/TR]
[TR]
[TD="align: right"]12/12/2014[/TD]
[TD="align: right"]36.5[/TD]
[TD][/TD]
[TD="align: right"]711.5[/TD]
[/TR]
[TR]
[TD="align: right"]11/12/2014[/TD]
[TD="align: right"]35.5[/TD]
[TD][/TD]
[TD="align: right"]711[/TD]
[/TR]
[TR]
[TD="align: right"]10/12/2014[/TD]
[TD="align: right"]37.5[/TD]
[TD][/TD]
[TD="align: right"]712.90002[/TD]
[/TR]
[TR]
[TD="align: right"]09/12/2014[/TD]
[TD="align: right"]38.5[/TD]
[TD][/TD]
[TD="align: right"]725.70001[/TD]
[/TR]
[TR]
[TD="align: right"]08/12/2014[/TD]
[TD="align: right"]42[/TD]
[TD][/TD]
[TD="align: right"]728.5[/TD]
[/TR]
[TR]
[TD="align: right"]05/12/2014[/TD]
[TD="align: right"]43[/TD]
[TD][/TD]
[TD="align: right"]729.79999[/TD]
[/TR]
[TR]
[TD="align: right"]04/12/2014[/TD]
[TD="align: right"]44[/TD]
[TD][/TD]
[TD="align: right"]727.5[/TD]
[/TR]
[TR]
[TD="align: right"]03/12/2014[/TD]
[TD="align: right"]44.5[/TD]
[TD][/TD]
[TD="align: right"]723.90002[/TD]
[/TR]
[TR]
[TD="align: right"]02/12/2014[/TD]
[TD="align: right"]45[/TD]
[TD][/TD]
[TD="align: right"]717.59998[/TD]
[/TR]
[TR]
[TD="align: right"]01/12/2014[/TD]
[TD="align: right"]44.5[/TD]
[TD][/TD]
[TD="align: right"]716.20001[/TD]
[/TR]
[TR]
[TD="align: right"]28/11/2014[/TD]
[TD="align: right"]46.5[/TD]
[TD][/TD]
[TD="align: right"]718.59998[/TD]
[/TR]
[TR]
[TD="align: right"]27/11/2014[/TD]
[TD="align: right"]47[/TD]
[TD][/TD]
[TD="align: right"]716.40002[/TD]
[/TR]
[TR]
[TD="align: right"]26/11/2014[/TD]
[TD="align: right"]47[/TD]
[TD][/TD]
[TD="align: right"]716.5[/TD]
[/TR]
[TR]
[TD="align: right"]25/11/2014[/TD]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD="align: right"]718.59998[/TD]
[/TR]
[TR]
[TD="align: right"]24/11/2014[/TD]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD="align: right"]718.29999[/TD]
[/TR]
[TR]
[TD="align: right"]21/11/2014[/TD]
[TD="align: right"]48.5[/TD]
[TD][/TD]
[TD="align: right"]721.40002[/TD]
[/TR]
[TR]
[TD="align: right"]20/11/2014[/TD]
[TD="align: right"]48.75[/TD]
[TD][/TD]
[TD="align: right"]723.29999[/TD]
[/TR]
[TR]
[TD="align: right"]19/11/2014[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD="align: right"]721.90002[/TD]
[/TR]
[TR]
[TD="align: right"]18/11/2014[/TD]
[TD="align: right"]50.75[/TD]
[TD][/TD]
[TD="align: right"]721.79999[/TD]
[/TR]
[TR]
[TD="align: right"]17/11/2014[/TD]
[TD="align: right"]53[/TD]
[TD][/TD]
[TD="align: right"]716.20001[/TD]
[/TR]
[TR]
[TD="align: right"]14/11/2014[/TD]
[TD="align: right"]55[/TD]
[TD][/TD]
[TD="align: right"]715.09998[/TD]
[/TR]
[TR]
[TD="align: right"]13/11/2014[/TD]
[TD="align: right"]56[/TD]
[TD][/TD]
[TD="align: right"]719.90002[/TD]
[/TR]
[TR]
[TD="align: right"]12/11/2014[/TD]
[TD="align: right"]53.5[/TD]
[TD][/TD]
[TD="align: right"]720.20001[/TD]
[/TR]
[TR]
[TD="align: right"]11/11/2014[/TD]
[TD="align: right"]53[/TD]
[TD][/TD]
[TD="align: right"]714.59998[/TD]
[/TR]
[TR]
[TD="align: right"]10/11/2014[/TD]
[TD="align: right"]52.5[/TD]
[TD][/TD]
[TD="align: right"]715.20001[/TD]
[/TR]
[TR]
[TD="align: right"]07/11/2014[/TD]
[TD="align: right"]54.5[/TD]
[TD][/TD]
[TD="align: right"]712.29999[/TD]
[/TR]
[TR]
[TD="align: right"]06/11/2014[/TD]
[TD="align: right"]55[/TD]
[TD][/TD]
[TD="align: right"]706.79999[/TD]
[/TR]
[TR]
[TD="align: right"]05/11/2014[/TD]
[TD="align: right"]51.5[/TD]
[TD][/TD]
[TD="align: right"]709[/TD]
[/TR]
[TR]
[TD="align: right"]04/11/2014[/TD]
[TD="align: right"]55[/TD]
[TD][/TD]
[TD="align: right"]708.90002[/TD]
[/TR]
[TR]
[TD="align: right"]03/11/2014[/TD]
[TD="align: right"]55[/TD]
[TD][/TD]
[TD="align: right"]709.29999[/TD]
[/TR]
[TR]
[TD="align: right"]31/10/2014[/TD]
[TD="align: right"]53.25[/TD]
[TD][/TD]
[TD="align: right"]705.20001[/TD]
[/TR]
[TR]
[TD="align: right"]30/10/2014[/TD]
[TD="align: right"]51.25[/TD]
[TD][/TD]
[TD="align: right"]692.40002[/TD]
[/TR]
[TR]
[TD="align: right"]29/10/2014[/TD]
[TD="align: right"]52.5[/TD]
[TD][/TD]
[TD="align: right"]689.09998[/TD]
[/TR]
[TR]
[TD="align: right"]28/10/2014[/TD]
[TD="align: right"]56.25[/TD]
[TD][/TD]
[TD="align: right"]676.29999[/TD]
[/TR]
[TR]
[TD="align: right"]27/10/2014[/TD]
[TD="align: right"]58.75[/TD]
[TD][/TD]
[TD="align: right"]681.20001[/TD]
[/TR]
[TR]
[TD="align: right"]24/10/2014[/TD]
[TD="align: right"]58.5[/TD]
[TD][/TD]
[TD="align: right"]698[/TD]
[/TR]
[TR]
[TD="align: right"]23/10/2014[/TD]
[TD="align: right"]61[/TD]
[TD][/TD]
[TD="align: right"]697.29999[/TD]
[/TR]
[TR]
[TD="align: right"]22/10/2014[/TD]
[TD="align: right"]66.5[/TD]
[TD][/TD]
[TD="align: right"]709.09998[/TD]
[/TR]
[TR]
[TD="align: right"]21/10/2014[/TD]
[TD="align: right"]61.75[/TD]
[TD][/TD]
[TD="align: right"]722.5[/TD]
[/TR]
[TR]
[TD="align: right"]20/10/2014[/TD]
[TD="align: right"]54[/TD]
[TD][/TD]
[TD="align: right"]727.59998[/TD]
[/TR]
[TR]
[TD="align: right"]17/10/2014[/TD]
[TD="align: right"]44[/TD]
[TD][/TD]
[TD="align: right"]736.20001[/TD]
[/TR]
[TR]
[TD="align: right"]16/10/2014[/TD]
[TD="align: right"]40.25[/TD]
[TD][/TD]
[TD="align: right"]740.79999[/TD]
[/TR]
[TR]
[TD="align: right"]15/10/2014[/TD]
[TD="align: right"]42[/TD]
[TD][/TD]
[TD="align: right"]739.59998[/TD]
[/TR]
[TR]
[TD="align: right"]14/10/2014[/TD]
[TD="align: right"]45[/TD]
[TD][/TD]
[TD="align: right"]737.70001[/TD]
[/TR]
[TR]
[TD="align: right"]13/10/2014[/TD]
[TD="align: right"]46.5[/TD]
[TD][/TD]
[TD="align: right"]743.79999[/TD]
[/TR]
[TR]
[TD="align: right"]10/10/2014[/TD]
[TD="align: right"]52[/TD]
[TD][/TD]
[TD="align: right"]750.09998[/TD]
[/TR]
[TR]
[TD="align: right"]09/10/2014[/TD]
[TD="align: right"]53.75[/TD]
[TD][/TD]
[TD="align: right"]749.59998[/TD]
[/TR]
[TR]
[TD="align: right"]08/10/2014[/TD]
[TD="align: right"]60.125[/TD]
[TD][/TD]
[TD="align: right"]749.5[/TD]
[/TR]
[TR]
[TD="align: right"]07/10/2014[/TD]
[TD="align: right"]64.25[/TD]
[TD][/TD]
[TD="align: right"]751.29999[/TD]
[/TR]
[TR]
[TD="align: right"]06/10/2014[/TD]
[TD="align: right"]65[/TD]
[TD][/TD]
[TD="align: right"]753.59998[/TD]
[/TR]
[TR]
[TD="align: right"]03/10/2014[/TD]
[TD="align: right"]66.75[/TD]
[TD][/TD]
[TD="align: right"]756.09998[/TD]
[/TR]
[TR]
[TD="align: right"]02/10/2014[/TD]
[TD="align: right"]66[/TD]
[TD][/TD]
[TD="align: right"]759.79999[/TD]
[/TR]
[TR]
[TD="align: right"]01/10/2014[/TD]
[TD="align: right"]66.5[/TD]
[TD][/TD]
[TD="align: right"]762.40002[/TD]
[/TR]
[TR]
[TD="align: right"]30/09/2014[/TD]
[TD="align: right"]67.375[/TD]
[TD][/TD]
[TD="align: right"]758.20001[/TD]
[/TR]
[TR]
[TD="align: right"]29/09/2014[/TD]
[TD="align: right"]63.5[/TD]
[TD][/TD]
[TD="align: right"]763.5[/TD]
[/TR]
[TR]
[TD="align: right"]26/09/2014[/TD]
[TD="align: right"]67.5[/TD]
[TD][/TD]
[TD="align: right"]765.20001[/TD]
[/TR]
[TR]
[TD="align: right"]25/09/2014[/TD]
[TD="align: right"]69[/TD]
[TD][/TD]
[TD="align: right"]772.70001[/TD]
[/TR]
[TR]
[TD="align: right"]24/09/2014[/TD]
[TD="align: right"]66.5[/TD]
[TD][/TD]
[TD="align: right"]776.90002[/TD]
[/TR]
[TR]
[TD="align: right"]23/09/2014[/TD]
[TD="align: right"]68.125[/TD]
[TD][/TD]
[TD="align: right"]776.09998[/TD]
[/TR]
[TR]
[TD="align: right"]22/09/2014[/TD]
[TD="align: right"]68[/TD]
[TD][/TD]
[TD="align: right"]775.59998[/TD]
[/TR]
[TR]
[TD="align: right"]19/09/2014[/TD]
[TD="align: right"]69.5[/TD]
[TD][/TD]
[TD="align: right"]777.09998[/TD]
[/TR]
[TR]
[TD="align: right"]18/09/2014[/TD]
[TD="align: right"]68.75[/TD]
[TD][/TD]
[TD="align: right"]776.20001[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2014[/TD]
[TD="align: right"]69.75[/TD]
[TD][/TD]
[TD="align: right"]779.29999[/TD]
[/TR]
[TR]
[TD="align: right"]16/09/2014[/TD]
[TD="align: right"]70.75[/TD]
[TD][/TD]
[TD="align: right"]777.40002[/TD]
[/TR]
[TR]
[TD="align: right"]15/09/2014[/TD]
[TD="align: right"]70.875[/TD]
[TD][/TD]
[TD="align: right"]778.90002[/TD]
[/TR]
[TR]
[TD="align: right"]12/09/2014[/TD]
[TD="align: right"]69.625[/TD]
[TD][/TD]
[TD="align: right"]779.79999[/TD]
[/TR]
[TR]
[TD="align: right"]11/09/2014[/TD]
[TD="align: right"]71.25[/TD]
[TD][/TD]
[TD="align: right"]779.09998[/TD]
[/TR]
[TR]
[TD="align: right"]10/09/2014[/TD]
[TD="align: right"]72[/TD]
[TD][/TD]
[TD="align: right"]780.5[/TD]
[/TR]
[TR]
[TD="align: right"]09/09/2014[/TD]
[TD="align: right"]71.5[/TD]
[TD][/TD]
[TD="align: right"]779[/TD]
[/TR]
[TR]
[TD="align: right"]08/09/2014[/TD]
[TD="align: right"]72[/TD]
[TD][/TD]
[TD="align: right"]779[/TD]
[/TR]
[TR]
[TD="align: right"]05/09/2014[/TD]
[TD="align: right"]75.25[/TD]
[TD][/TD]
[TD="align: right"]770.29999[/TD]
[/TR]
[TR]
[TD="align: right"]04/09/2014[/TD]
[TD="align: right"]74.375[/TD]
[TD][/TD]
[TD="align: right"]764.09998[/TD]
[/TR]
[TR]
[TD="align: right"]03/09/2014[/TD]
[TD="align: right"]70.5[/TD]
[TD][/TD]
[TD="align: right"]764[/TD]
[/TR]
[TR]
[TD="align: right"]02/09/2014[/TD]
[TD="align: right"]69.75[/TD]
[TD][/TD]
[TD="align: right"]764.29999[/TD]
[/TR]
[TR]
[TD="align: right"]01/09/2014[/TD]
[TD="align: right"]70.25[/TD]
[TD][/TD]
[TD="align: right"]763.29999[/TD]
[/TR]
[TR]
[TD="align: right"]29/08/2014[/TD]
[TD="align: right"]70.75[/TD]
[TD][/TD]
[TD="align: right"]759.29999[/TD]
[/TR]
[TR]
[TD="align: right"]28/08/2014[/TD]
[TD="align: right"]73.5[/TD]
[TD][/TD]
[TD="align: right"]756.29999[/TD]
[/TR]
[TR]
[TD="align: right"]27/08/2014[/TD]
[TD="align: right"]69.25[/TD]
[TD][/TD]
[TD="align: right"]754.79999[/TD]
[/TR]
[TR]
[TD="align: right"]26/08/2014[/TD]
[TD="align: right"]69.75[/TD]
[TD][/TD]
[TD="align: right"]755.70001[/TD]
[/TR]
[TR]
[TD="align: right"]25/08/2014[/TD]
[TD="align: right"]72.75[/TD]
[TD][/TD]
[TD="align: right"]755.79999[/TD]
[/TR]
[TR]
[TD="align: right"]22/08/2014[/TD]
[TD="align: right"]72.75[/TD]
[TD][/TD]
[TD="align: right"]753.40002[/TD]
[/TR]
[TR]
[TD="align: right"]21/08/2014[/TD]
[TD="align: right"]76.5[/TD]
[TD][/TD]
[TD="align: right"]749.40002[/TD]
[/TR]
[TR]
[TD="align: right"]20/08/2014[/TD]
[TD="align: right"]78.875[/TD]
[TD][/TD]
[TD="align: right"]750.09998[/TD]
[/TR]
[TR]
[TD="align: right"]19/08/2014[/TD]
[TD="align: right"]81[/TD]
[TD][/TD]
[TD="align: right"]751.29999[/TD]
[/TR]
[TR]
[TD="align: right"]18/08/2014[/TD]
[TD="align: right"]83.25[/TD]
[TD][/TD]
[TD="align: right"]755.70001[/TD]
[/TR]
[TR]
[TD="align: right"]15/08/2014[/TD]
[TD="align: right"]83.75[/TD]
[TD][/TD]
[TD="align: right"]756.09998[/TD]
[/TR]
[TR]
[TD="align: right"]14/08/2014[/TD]
[TD="align: right"]79.75[/TD]
[TD][/TD]
[TD="align: right"]762.40002[/TD]
[/TR]
[TR]
[TD="align: right"]13/08/2014[/TD]
[TD="align: right"]80.5[/TD]
[TD][/TD]
[TD="align: right"]768.59998[/TD]
[/TR]
[TR]
[TD="align: right"]12/08/2014[/TD]
[TD="align: right"]81.875[/TD]
[TD][/TD]
[TD="align: right"]772.29999[/TD]
[/TR]
[TR]
[TD="align: right"]11/08/2014[/TD]
[TD="align: right"]85[/TD]
[TD][/TD]
[TD="align: right"]771.29999[/TD]
[/TR]
[TR]
[TD="align: right"]08/08/2014[/TD]
[TD="align: right"]74.5[/TD]
[TD][/TD]
[TD="align: right"]771.70001[/TD]
[/TR]
[TR]
[TD="align: right"]07/08/2014[/TD]
[TD="align: right"]73.25[/TD]
[TD][/TD]
[TD="align: right"]773.20001[/TD]
[/TR]
[TR]
[TD="align: right"]06/08/2014[/TD]
[TD="align: right"]67.125[/TD]
[TD][/TD]
[TD="align: right"]773.20001[/TD]
[/TR]
[TR]
[TD="align: right"]05/08/2014[/TD]
[TD="align: right"]68[/TD]
[TD][/TD]
[TD="align: right"]773.09998[/TD]
[/TR]
[TR]
[TD="align: right"]04/08/2014[/TD]
[TD="align: right"]65.5[/TD]
[TD][/TD]
[TD="align: right"]772.59998[/TD]
[/TR]
[TR]
[TD="align: right"]01/08/2014[/TD]
[TD="align: right"]68[/TD]
[TD][/TD]
[TD="align: right"]769.29999[/TD]
[/TR]
[TR]
[TD="align: right"]31/07/2014[/TD]
[TD="align: right"]67.25[/TD]
[TD][/TD]
[TD="align: right"]768.29999[/TD]
[/TR]
[TR]
[TD="align: right"]30/07/2014[/TD]
[TD="align: right"]72.625[/TD]
[TD][/TD]
[TD="align: right"]769.59998[/TD]
[/TR]
[TR]
[TD="align: right"]29/07/2014[/TD]
[TD="align: right"]78.25[/TD]
[TD][/TD]
[TD="align: right"]775.40002[/TD]
[/TR]
[TR]
[TD="align: right"]28/07/2014[/TD]
[TD="align: right"]86.75[/TD]
[TD][/TD]
[TD="align: right"]773.29999[/TD]
[/TR]
[TR]
[TD="align: right"]25/07/2014[/TD]
[TD="align: right"]85[/TD]
[TD][/TD]
[TD="align: right"]775.29999[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
Hi Afro15, welcome to the boards.

Can you give a little more detail as to what you are trying to achieve please? If I am honest I do not quite follow what you are trying to do and without context the example data you have supplied doesn't indicate what result you are expecting.
 
Upvote 0
Thanks for the quick reply Fishboy. I am trying to compare the daily closing price of a stock(data on left hand side) to the closing price of an index(data on right hand side) and then plot the two on a share price chart.. really not sure how to do this
 
Upvote 0
Hmmm, I suspect there are a number of ways this could be achieved but they will all vary heavily based on how you are looking to have the data interpreted and what style of chart / graph you are looking to use. Sorry to throw this back at you again but if you can elaborate on what the chart should show (is it literally the bigger value compared to the smaller value, the bigger value minus the smaller value?), I will have another look and see if I can offer any help.
 
Upvote 0
So 25/07/2014 for example stock price is 85, index price is 775.29 - if I could make these comparable (perhapsto 100) I could then plot them on a line graph that compares the stock price to the index price for a given date? It is just the bigger value to the smaller value but in a way thats comparable

Thanks for your help, I'm so confused!
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Solved
Age Group Ranging by gender
Replies
2
Views
231
Raj1979
R
D
  • Question Question
Formula help needed for working with days and times.
Replies
0
Views
247
dshtesy
D
S
  • Solved
Count of active employees between dates.
Replies
3
Views
628
Fluff
Fluff
R
  • Solved
transpose data with same value in column A by date order
Replies
5
Views
389
Fluff
Fluff
M
  • Question Question
HELP IDENTIFY ORIGINAL START DATE BASED ON CONTINOUS SERVICE RULES
Replies
0
Views
540
mrshuck
M

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

Share this page

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