Matching Dates

mlarson · Sep 26, 2011

Hi all, I have a moderately difficult question. Well, if you’re really good at this it will probably be easy for you, but it’s difficult for me as I’m not an expert with Excel. I am aware there are other posts on matching but I did not find one that matched in the way I describe below.

I would like to match data from Workbook1 to Workbook2 (each workbook is below). If the date in column C in Workbook1 matches the date in column C in Workbook2, then I want the value in column F of Workbook1 to be placed in column F of Workbook2.

For example, the date in cell C2 (Workbook1) is identical to the dates in cells C2, C3, C4 (Workbook2). Therefore, the value of 1.25 from cell F2 (Workbook1) should be placed in cell F2 of Workbook2 (column F in Workbook2 would be blank prior to the macro being run and placing the appropriate values in those cells).

Is there a macro that can do this easily? My spreadsheet will have roughly 100,000 rows. Thanks in advance for your help.

Workbook1

<table border="0" cellpadding="0" cellspacing="0" width="408"><col style="width: 48pt;" width="64" span="2"> <col style="width: 66pt;" width="88"> <col style="width: 48pt;" width="64" span="3"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; width: 48pt;" width="64" height="20">A</td> <td class="xl63" style="width: 48pt;" width="64">B</td> <td class="xl63" style="width: 66pt;" width="88">C</td> <td class="xl63" style="width: 48pt;" width="64">D</td> <td class="xl63" style="width: 48pt;" width="64">E</td> <td class="xl63" style="width: 48pt;" width="64">F</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt;" height="20">2</td> <td class="xl63">ABCD</td> <td class="xl64">9/1/2010</td> <td class="xl65">464.20</td> <td class="xl65">462.47</td> <td class="xl63">1.25</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt;" height="20">3</td> <td class="xl63">ABCD</td> <td class="xl64">9/2/2010</td> <td class="xl65">462.87</td> <td class="xl65">461.57</td> <td class="xl63">1.34</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt;" height="20">4</td> <td class="xl63">ABCD</td> <td class="xl64">9/3/2010</td> <td class="xl65">470.18</td> <td class="xl65">471.78</td> <td class="xl63">1.32</td> </tr> </tbody></table>
Workbook2/Output
<table border="0" cellpadding="0" cellspacing="0" width="408"><col style="width: 48pt;" width="64" span="2"> <col style="width: 66pt;" width="88"> <col style="width: 48pt;" width="64" span="3"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 48pt;" width="64" height="20">A</td> <td class="xl65" style="width: 48pt;" width="64">B</td> <td class="xl65" style="width: 66pt;" width="88">C</td> <td class="xl65" style="width: 48pt;" width="64">D</td> <td class="xl65" style="width: 48pt;" width="64">E</td> <td class="xl65" style="width: 48pt;" width="64">F</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">2</td> <td class="xl65">ABCD</td> <td class="xl66">9/1/2010</td> <td class="xl68">11:01</td> <td class="xl67">464.20</td> <td class="xl65">1.25</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">3</td> <td class="xl65">ABCD</td> <td class="xl66">9/1/2010</td> <td class="xl68">11:02</td> <td class="xl67">464.25</td> <td class="xl65">1.25</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">4</td> <td class="xl65">ABCD</td> <td class="xl66">9/1/2010</td> <td class="xl68">11:03</td> <td class="xl67">464.55</td> <td class="xl65">1.25</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">5</td> <td class="xl65">ABCD</td> <td class="xl66">9/2/2010</td> <td class="xl68">11:01</td> <td class="xl67">464.30</td> <td class="xl65">1.34</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">6</td> <td class="xl65">ABCD</td> <td class="xl66">9/2/2010</td> <td class="xl68">11:02</td> <td class="xl67">465.10</td> <td class="xl65">1.34</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">7</td> <td class="xl65">ABCD</td> <td class="xl66">9/2/2010</td> <td class="xl68">11:03</td> <td class="xl67">464.85</td> <td class="xl65">1.34</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">8</td> <td class="xl65">ABCD</td> <td class="xl66">9/3/2010</td> <td class="xl68">11:01</td> <td class="xl67">465.10</td> <td class="xl65">1.32</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">9</td> <td class="xl65">ABCD</td> <td class="xl66">9/3/2010</td> <td class="xl68">11:02</td> <td class="xl67">465.04</td> <td class="xl65">1.32</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">10</td> <td class="xl65">ABCD</td> <td class="xl66">9/3/2010</td> <td class="xl68">11:03</td> <td class="xl67">465.21</td> <td class="xl65">1.32</td> </tr> </tbody></table>

niceguy_jay · Oct 5, 2011

if the formula is not working then I am afraid even the macro wont work...probably there is some lack of understanding among us...
can you share some live data which is catching error...maybe that way I can understand the problem better....

mlarson · Oct 5, 2011

Here is the actual data used. Perhaps it has something to do with matching values that are "time" that could be messing it up?
Column A (date), B (time), H (days to maturity), J (strike price), K (weekday).

So, for example, the 2nd row in Workbook2.xlsm matches with the 1st row in Workbook1.xlsm. The value of 6.1 (Column F or "Close" of Workbook1) should be placed in Column M (or "Output") of Workbook2.

I hope this info helps.

Workbook2.xlsm (note Output column)
<table border="0" cellpadding="0" cellspacing="0" width="832"><col style="width: 48pt;" width="64" span="13"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 48pt;" width="64" height="20">Date</td> <td class="xl65" style="width: 48pt;" width="64">Time</td> <td class="xl65" style="width: 48pt;" width="64">Open</td> <td class="xl65" style="width: 48pt;" width="64">High</td> <td class="xl65" style="width: 48pt;" width="64">Low</td> <td class="xl65" style="width: 48pt;" width="64">Close</td> <td class="xl65" style="width: 48pt;" width="64">Put/Call Indicator</td> <td class="xl65" style="width: 48pt;" width="64">Days To Maturity</td> <td class="xl65" style="width: 48pt;" width="64">Symbol</td> <td class="xl65" style="width: 48pt;" width="64">Strike Price</td> <td class="xl65" style="width: 48pt;" width="64">Weekday</td> <td class="xl65" style="width: 48pt;" width="64">Keep/Delete</td> <td class="xl65" style="width: 48pt;" align="right" width="64">Output
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl67">9:31</td> <td class="xl65">0.65</td> <td class="xl65">0.8</td> <td class="xl65">0.6</td> <td class="xl65">0.8</td> <td class="xl65">P</td> <td class="xl65">0</td> <td class="xl65">GOOG</td> <td class="xl65">500</td> <td class="xl65">Friday</td> <td class="xl65">KEEP</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl67">9:32</td> <td class="xl65">0.66</td> <td class="xl65">0.7</td> <td class="xl65">0.55</td> <td class="xl65">0.55</td> <td class="xl65">P</td> <td class="xl65">0</td> <td class="xl65">GOOG</td> <td class="xl65">500</td> <td class="xl65">Friday</td> <td class="xl65">KEEP</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl67">9:33</td> <td class="xl65">0.65</td> <td class="xl65">0.65</td> <td class="xl65">0.65</td> <td class="xl65">0.65</td> <td class="xl65">P</td> <td class="xl65">0</td> <td class="xl65">GOOG</td> <td class="xl65">500</td> <td class="xl65">Friday</td> <td class="xl65">KEEP</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl67">9:34</td> <td class="xl65">0.65</td> <td class="xl65">0.71</td> <td class="xl65">0.6</td> <td class="xl65">0.6</td> <td class="xl65">P</td> <td class="xl65">0</td> <td class="xl65">GOOG</td> <td class="xl65">500</td> <td class="xl65">Friday</td> <td class="xl65">KEEP</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl67">9:35</td> <td class="xl65">0.61</td> <td class="xl65">0.69</td> <td class="xl65">0.61</td> <td class="xl65">0.65</td> <td class="xl65">P</td> <td class="xl65">0</td> <td class="xl65">GOOG</td> <td class="xl65">500</td> <td class="xl65">Friday</td> <td class="xl65">KEEP</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl67">9:36</td> <td class="xl65">0.7</td> <td class="xl65">0.7</td> <td class="xl65">0.6</td> <td class="xl65">0.7</td> <td class="xl65">P</td> <td class="xl65">0</td> <td class="xl65">GOOG</td> <td class="xl65">500</td> <td class="xl65">Friday</td> <td class="xl65">KEEP</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl67">9:37</td> <td class="xl65">0.7</td> <td class="xl65">0.7</td> <td class="xl65">0.65</td> <td class="xl65">0.65</td> <td class="xl65">P</td> <td class="xl65">0</td> <td class="xl65">GOOG</td> <td class="xl65">500</td> <td class="xl65">Friday</td> <td class="xl65">KEEP</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl67">9:38</td> <td class="xl65">0.65</td> <td class="xl65">0.65</td> <td class="xl65">0.6</td> <td class="xl65">0.6</td> <td class="xl65">P</td> <td class="xl65">0</td> <td class="xl65">GOOG</td> <td class="xl65">500</td> <td class="xl65">Friday</td> <td class="xl65">KEEP</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl67">9:39</td> <td class="xl65">0.7</td> <td class="xl65">0.8</td> <td class="xl65">0.65</td> <td class="xl65">0.8</td> <td class="xl65">P</td> <td class="xl65">0</td> <td class="xl65">GOOG</td> <td class="xl65">500</td> <td class="xl65">Friday</td> <td class="xl65">KEEP</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl67">9:40</td> <td class="xl65">0.9</td> <td class="xl65">1</td> <td class="xl65">0.85</td> <td class="xl65">1</td> <td class="xl65">P</td> <td class="xl65">0</td> <td class="xl65">GOOG</td> <td class="xl65">500</td> <td class="xl65">Friday</td> <td class="xl65">KEEP</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl67">9:41</td> <td class="xl65">0.97</td> <td class="xl65">1</td> <td class="xl65">0.75</td> <td class="xl65">0.95</td> <td class="xl65">P</td> <td class="xl65">0</td> <td class="xl65">GOOG</td> <td class="xl65">500</td> <td class="xl65">Friday</td> <td class="xl65">KEEP</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl67">9:42</td> <td class="xl65">0.95</td> <td class="xl65">0.95</td> <td class="xl65">0.95</td> <td class="xl65">0.95</td> <td class="xl65">P</td> <td class="xl65">0</td> <td class="xl65">GOOG</td> <td class="xl65">500</td> <td class="xl65">Friday</td> <td class="xl65">KEEP</td> <td>
</td> </tr> </tbody></table>
Workbook1.xlsm (note absence of Output column)
<table border="0" cellpadding="0" cellspacing="0" width="768"><col style="width: 48pt;" width="64" span="12"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; width: 48pt;" width="64" height="20">Date</td> <td class="xl63" style="width: 48pt;" width="64">Time</td> <td class="xl63" style="width: 48pt;" width="64">Open</td> <td class="xl63" style="width: 48pt;" width="64">High</td> <td class="xl63" style="width: 48pt;" width="64">Low</td> <td class="xl63" style="width: 48pt;" width="64">Close</td> <td class="xl63" style="width: 48pt;" width="64">Put/Call Indicator</td> <td class="xl63" style="width: 48pt;" width="64">Days To Maturity</td> <td class="xl63" style="width: 48pt;" width="64">Symbol</td> <td class="xl63" style="width: 48pt;" width="64">Strike Price</td> <td class="xl63" style="width: 48pt;" width="64">Weekday</td> <td class="xl64" style="width: 48pt;" width="64">Keep/Delete</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl66">9:31</td> <td class="xl63">18.1</td> <td class="xl63">18.1</td> <td class="xl63">18.1</td> <td class="xl63">18.1</td> <td class="xl63">C</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">490</td> <td class="xl63">Friday</td> <td class="xl64">KEEP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl66">9:31</td> <td class="xl63">6.1</td> <td class="xl63">6.1</td> <td class="xl63">6.1</td> <td class="xl63">6.1</td> <td class="xl63">C</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl64">KEEP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl66">9:31</td> <td class="xl63">0.65</td> <td class="xl63">0.85</td> <td class="xl63">0.5</td> <td class="xl63">0.5</td> <td class="xl63">C</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">510</td> <td class="xl63">Friday</td> <td class="xl64">KEEP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl66">9:32</td> <td class="xl63">18.1</td> <td class="xl63">18.1</td> <td class="xl63">18.1</td> <td class="xl63">18.1</td> <td class="xl63">C</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">490</td> <td class="xl63">Friday</td> <td class="xl64">KEEP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl66">9:32</td> <td class="xl63">5.4</td> <td class="xl63">5.4</td> <td class="xl63">5.4</td> <td class="xl63">5.4</td> <td class="xl63">C</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl64">KEEP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl66">9:32</td> <td class="xl63">0.4</td> <td class="xl63">0.5</td> <td class="xl63">0.35</td> <td class="xl63">0.4</td> <td class="xl63">C</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">510</td> <td class="xl63">Friday</td> <td class="xl64">KEEP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl66">9:33</td> <td class="xl63">24.3</td> <td class="xl63">24.3</td> <td class="xl63">24.3</td> <td class="xl63">24.3</td> <td class="xl63">C</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">480</td> <td class="xl63">Friday</td> <td class="xl64">KEEP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl66">9:33</td> <td class="xl63">14.5</td> <td class="xl63">14.5</td> <td class="xl63">14.5</td> <td class="xl63">14.5</td> <td class="xl63">C</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">490</td> <td class="xl63">Friday</td> <td class="xl64">KEEP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl66">9:33</td> <td class="xl63">5.5</td> <td class="xl63">5.5</td> <td class="xl63">5</td> <td class="xl63">5</td> <td class="xl63">C</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl64">KEEP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl66">9:33</td> <td class="xl63">0.5</td> <td class="xl63">0.5</td> <td class="xl63">0.35</td> <td class="xl63">0.35</td> <td class="xl63">C</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">510</td> <td class="xl63">Friday</td> <td class="xl64">KEEP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl66">9:34</td> <td class="xl63">24.3</td> <td class="xl63">24.3</td> <td class="xl63">24.3</td> <td class="xl63">24.3</td> <td class="xl63">C</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">480</td> <td class="xl63">Friday</td> <td class="xl64">KEEP</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl66">9:34</td> <td class="xl63">14.5</td> <td class="xl63">14.5</td> <td class="xl63">14.5</td> <td class="xl63">14.5</td> <td class="xl63">C</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">490</td> <td class="xl63">Friday</td> <td class="xl64">KEEP</td> </tr> </tbody></table>

Formula used (tried it in cell M1 and M2 of Workbook2 but no luck):

Code:

=INDIRECT("[Workbook1.xlsm]Sheet1!$F"&IF(ISERROR(AND(VLOOKUP($A1,[Workbook1.xlsm]Sheet1!$A:$A,1,FALSE),VLOOKUP($B1,[Workbook1.xlsm]Sheet1!$B:$B,1,FALSE),VLOOKUP($H1,[Workbook1.xlsm]Sheet1!$H:$H,1,FALSE),VLOOKUP($J1,[Workbook1.xlsm]Sheet1!$J:$J,1,FALSE),VLOOKUP($K1,[Workbook1.xlsm]Sheet1!$K:$K,1,FALSE))),"NA",MATCH(A1,[Workbook1.xlsm]Sheet1!$A:$A,0)))

niceguy_jay · Oct 5, 2011

hmmm...let me try on this

mlarson · Oct 5, 2011

Thanks, I look forward to seeing what you find.

mlarson · Oct 5, 2011

Jay, do you think an INDEX/MATCH might work? I've never used something like that before but just read up about it and some suggest it is better than VLOOKUP.

niceguy_jay · Oct 5, 2011

exactly...even I had been trying with that...both..INDEX/MATCH....
MATCH seemed to return the values to better extent so as to VLOOKUP with the criteria..
I had a hectic day in office so was not able to concentrate that much...
hope you have some buffer time that WE come up with an ultimate solution..

mlarson · Oct 5, 2011

Thanks for your continued help on this, Jay. I think we'll be able to figure it out. You're likely more experienced than I am as I'm essentially a beginner but I will be racking my brain trying to figure this out until it's done. It will certainly be nice once it's completed!

By the way, if anybody else out there wants to help we could make this a group effort and beers will be on me to celebrate

niceguy_jay · Oct 6, 2011

finally this one is working for me on your sample data...have a check....

=IFERROR(INDIRECT("[Workbook1.xls]Sheet1!$F"&IF(AND(MATCH($A2,[Workbook1.xls]Sheet1!$A:$A,0),MATCH($B2,[Workbook1.xls]Sheet1!$B:$B,0),MATCH($H2,[Workbook1.xls]Sheet1!$H:$H,0),MATCH($J2,[Workbook1.xls]Sheet1!$J:$J,0),MATCH($K2,[Workbook1.xls]Sheet1!$K:$K,0)),MATCH($B2,[Workbook1.xls]Sheet1!$B:$B,0),"NA")),"NA")

mlarson · Oct 6, 2011

It looks like we're close. I ran that formula and have the output (and desired output) shown below. The formula seems to be ignoring strike price (column J), but J is in the formula. Any thoughts on why it's not matching J? Note: only 3 desired outputs shown below as I would need to include a larger sample size for the blank desired output cells to contain values.

<table border="0" cellpadding="0" cellspacing="0" width="967"><col style="width: 71pt;" width="95"> <col style="width: 48pt;" width="64" span="12"> <col style="width: 78pt;" width="104"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; width: 71pt;" width="95" height="20">Date</td> <td class="xl63" style="width: 48pt;" width="64">Time</td> <td class="xl63" style="width: 48pt;" width="64">Open</td> <td class="xl63" style="width: 48pt;" width="64">High</td> <td class="xl63" style="width: 48pt;" width="64">Low</td> <td class="xl63" style="width: 48pt;" width="64">Close</td> <td class="xl63" style="width: 48pt;" width="64">Put/Call Indicator</td> <td class="xl63" style="width: 48pt;" width="64">Days To Maturity</td> <td class="xl63" style="width: 48pt;" width="64">Symbol</td> <td class="xl63" style="width: 48pt;" width="64">Strike Price</td> <td class="xl63" style="width: 48pt;" width="64">Weekday</td> <td class="xl63" style="width: 48pt;" width="64">Keep/Delete</td> <td class="xl63" style="width: 48pt;" width="64">Output</td> <td class="xl63" style="width: 78pt;" width="104">Desired Output</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl65">9:31</td> <td class="xl63">0.65</td> <td class="xl63">0.8</td> <td class="xl63">0.6</td> <td class="xl63">0.8</td> <td class="xl63">P</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl63">KEEP</td> <td align="right">18.1</td> <td class="xl66" align="right">6.10</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl65">9:32</td> <td class="xl63">0.66</td> <td class="xl63">0.7</td> <td class="xl63">0.55</td> <td class="xl63">0.55</td> <td class="xl63">P</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl63">KEEP</td> <td align="right">18.1</td> <td class="xl66" align="right">5.40</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl65">9:33</td> <td class="xl63">0.65</td> <td class="xl63">0.65</td> <td class="xl63">0.65</td> <td class="xl63">0.65</td> <td class="xl63">P</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl63">KEEP</td> <td align="right">24.3</td> <td class="xl66" align="right">5.00</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl65">9:34</td> <td class="xl63">0.65</td> <td class="xl63">0.71</td> <td class="xl63">0.6</td> <td class="xl63">0.6</td> <td class="xl63">P</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl63">KEEP</td> <td align="right">24.3</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl65">9:35</td> <td class="xl63">0.61</td> <td class="xl63">0.69</td> <td class="xl63">0.61</td> <td class="xl63">0.65</td> <td class="xl63">P</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl63">KEEP</td> <td align="right">24.3</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl65">9:36</td> <td class="xl63">0.7</td> <td class="xl63">0.7</td> <td class="xl63">0.6</td> <td class="xl63">0.7</td> <td class="xl63">P</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl63">KEEP</td> <td align="right">24.3</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl65">9:37</td> <td class="xl63">0.7</td> <td class="xl63">0.7</td> <td class="xl63">0.65</td> <td class="xl63">0.65</td> <td class="xl63">P</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl63">KEEP</td> <td align="right">24.3</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl65">9:38</td> <td class="xl63">0.65</td> <td class="xl63">0.65</td> <td class="xl63">0.6</td> <td class="xl63">0.6</td> <td class="xl63">P</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl63">KEEP</td> <td align="right">24.3</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl65">9:39</td> <td class="xl63">0.7</td> <td class="xl63">0.8</td> <td class="xl63">0.65</td> <td class="xl63">0.8</td> <td class="xl63">P</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl63">KEEP</td> <td align="right">24.3</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl65">9:40</td> <td class="xl63">0.9</td> <td class="xl63">1</td> <td class="xl63">0.85</td> <td class="xl63">1</td> <td class="xl63">P</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl63">KEEP</td> <td align="right">24.3</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl65">9:41</td> <td class="xl63">0.97</td> <td class="xl63">1</td> <td class="xl63">0.75</td> <td class="xl63">0.95</td> <td class="xl63">P</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl63">KEEP</td> <td align="right">24.3</td> <td class="xl66">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">8/6/2010</td> <td class="xl65">9:42</td> <td class="xl63">0.95</td> <td class="xl63">0.95</td> <td class="xl63">0.95</td> <td class="xl63">0.95</td> <td class="xl63">P</td> <td class="xl63">0</td> <td class="xl63">GOOG</td> <td class="xl63">500</td> <td class="xl63">Friday</td> <td class="xl63">KEEP</td> <td align="right">24.3</td> <td class="xl66">
</td> </tr> </tbody></table>

niceguy_jay · Oct 6, 2011

I got what the problem is...in order to solve it...just one question...seems like you are capturing data from some live source...is it possible for you to capture the first column i.e. Date with hours, minutes and seconds as well..

Matching Dates

mlarson

Well-known Member

niceguy_jay

Board Regular

Excel Facts

mlarson

Well-known Member

niceguy_jay

Board Regular

mlarson

Well-known Member

mlarson

Well-known Member

niceguy_jay

Board Regular

mlarson

Well-known Member

niceguy_jay

Board Regular

mlarson

Well-known Member

niceguy_jay

Board Regular

Similar threads

Forum statistics

Share this page

Matching Dates

Well-known Member

Board Regular

Excel Facts

Well-known Member

Board Regular

Well-known Member

Well-known Member

Board Regular

Well-known Member

Board Regular

Well-known Member

Board Regular

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock