Index Match Issue

H

healey21

Well-known Member
Joined
Dec 22, 2009
Messages
900
I am trying to use index and match to find a value based on a persons name and date they did some work for us. But unfortunally I am missing something. A2 has a name, A5 has a date B11 is to hold the formula to get total from the cash sheet based on these 2 conditions. Would someone look over the formula and inform me where I have gone wrong. Thank you...

Main Sheet to show the result is as follows:

Log


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 151px"><COL style="WIDTH: 82px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD>Karen</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD>Week Commencing</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">20/02/2011</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD>Daily Amount</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD>Date</TD><TD>Cash Jobs</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right">Sun 20/02/2011</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">#N/A</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right">Mon 21/02/2011</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: right">Tue 22/02/2011</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: right">Wed 23/02/2011</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: right">Thu 24/02/2011</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: right">Fri 25/02/2011</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: right">Sat 26/02/2011</TD><TD></TD></TR></TBODY></TABLE>


<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>A11</TD><TD>=A5</TD></TR><TR><TD>B11</TD><TD>{=INDEX(Cash!F:F,MATCH(1,(A2=Cash!E:E)*(Cash!C:C),0))}</TD></TR><TR><TD>A12</TD><TD>=A11+1</TD></TR><TR><TD>A13</TD><TD>=A12+1</TD></TR><TR><TD>A14</TD><TD>=A13+1</TD></TR><TR><TD>A15</TD><TD>=A14+1</TD></TR><TR><TD>A16</TD><TD>=A15+1</TD></TR><TR><TD>A17</TD><TD>=A16+1</TD></TR></TBODY></TABLE></TD></TR><TR><TD>Formula Array:
Produce enclosing { } by entering
formula with CTRL+SHIFT+ENTER!
</TD></TR></TBODY></TABLE>


Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

The data sheet to check is called Cash an example is shown below

Cash

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 47px"><COL style="WIDTH: 129px"><COL style="WIDTH: 103px"><COL style="WIDTH: 139px"><COL style="WIDTH: 69px"><COL style="WIDTH: 57px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: center">No</TD><TD style="TEXT-ALIGN: center">Week Commencing</TD><TD style="TEXT-ALIGN: center">Shift Date</TD><TD style="TEXT-ALIGN: center">Date & Time</TD><TD style="TEXT-ALIGN: center">Employee</TD><TD style="TEXT-ALIGN: center">Amount</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: center">10</TD><TD style="TEXT-ALIGN: center">05/12/2010</TD><TD style="TEXT-ALIGN: center">Tue 07/Dec/10</TD><TD style="TEXT-ALIGN: center">Tue 07/Dec/10 08:34</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: center">12</TD><TD style="TEXT-ALIGN: center">05/12/2010</TD><TD style="TEXT-ALIGN: center">Thu 09/Dec/10</TD><TD style="TEXT-ALIGN: center">Thu 09/Dec/10 18:19</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£10.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: center">17</TD><TD style="TEXT-ALIGN: center">05/12/2010</TD><TD style="TEXT-ALIGN: center">Fri 10/Dec/10</TD><TD style="TEXT-ALIGN: center">Fri 10/Dec/10 14:20</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.27</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: center">11</TD><TD style="TEXT-ALIGN: center">05/12/2010</TD><TD style="TEXT-ALIGN: center">Fri 10/Dec/10</TD><TD style="TEXT-ALIGN: center">Fri 10/Dec/10 19:39</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£10.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: center">13</TD><TD style="TEXT-ALIGN: center">05/12/2010</TD><TD style="TEXT-ALIGN: center">Sat 11/Dec/10</TD><TD style="TEXT-ALIGN: center">Sat 11/Dec/10 17:01</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center">14</TD><TD style="TEXT-ALIGN: center">12/12/2010</TD><TD style="TEXT-ALIGN: center">Mon 13/Dec/10</TD><TD style="TEXT-ALIGN: center">Mon 13/Dec/10 18:28</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: center">16</TD><TD style="TEXT-ALIGN: center">12/12/2010</TD><TD style="TEXT-ALIGN: center">Wed 15/Dec/10</TD><TD style="TEXT-ALIGN: center">Wed 15/Dec/10 11:47</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: center">15</TD><TD style="TEXT-ALIGN: center">12/12/2010</TD><TD style="TEXT-ALIGN: center">Thu 16/Dec/10</TD><TD style="TEXT-ALIGN: center">Thu 16/Dec/10 20:04</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: center">18</TD><TD style="TEXT-ALIGN: center">12/12/2010</TD><TD style="TEXT-ALIGN: center">Fri 17/Dec/10</TD><TD style="TEXT-ALIGN: center">Fri 17/Dec/10 16:22</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: center">19</TD><TD style="TEXT-ALIGN: center">12/12/2010</TD><TD style="TEXT-ALIGN: center">Sat 18/Dec/10</TD><TD style="TEXT-ALIGN: center">Sat 18/Dec/10 17:09</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: center">20</TD><TD style="TEXT-ALIGN: center">19/12/2010</TD><TD style="TEXT-ALIGN: center">Tue 21/Dec/10</TD><TD style="TEXT-ALIGN: center">Tue 21/Dec/10 09:05</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: center">21</TD><TD style="TEXT-ALIGN: center">19/12/2010</TD><TD style="TEXT-ALIGN: center">Wed 22/Dec/10</TD><TD style="TEXT-ALIGN: center">Wed 22/Dec/10 13:29</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: center">23</TD><TD style="TEXT-ALIGN: center">19/12/2010</TD><TD style="TEXT-ALIGN: center">Fri 24/Dec/10</TD><TD style="TEXT-ALIGN: center">Fri 24/Dec/10 13:17</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: center">22</TD><TD style="TEXT-ALIGN: center">26/12/2010</TD><TD style="TEXT-ALIGN: center">Sun 26/Dec/10</TD><TD style="TEXT-ALIGN: center">Sun 26/Dec/10 12:09</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: center">24</TD><TD style="TEXT-ALIGN: center">26/12/2010</TD><TD style="TEXT-ALIGN: center">Tue 28/Dec/10</TD><TD style="TEXT-ALIGN: center">Tue 28/Dec/10 09:38</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: center">25</TD><TD style="TEXT-ALIGN: center">26/12/2010</TD><TD style="TEXT-ALIGN: center">Thu 30/Dec/10</TD><TD style="TEXT-ALIGN: center">Thu 30/Dec/10 10:59</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: center">26</TD><TD style="TEXT-ALIGN: center">26/12/2010</TD><TD style="TEXT-ALIGN: center">Fri 31/Dec/10</TD><TD style="TEXT-ALIGN: center">Fri 31/Dec/10 15:15</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£25.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: center">27</TD><TD style="TEXT-ALIGN: center">02/01/2011</TD><TD style="TEXT-ALIGN: center">Sun 02/Jan/11</TD><TD style="TEXT-ALIGN: center">Sun 02/Jan/11 10:12</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: center">28</TD><TD style="TEXT-ALIGN: center">02/01/2011</TD><TD style="TEXT-ALIGN: center">Mon 03/Jan/11</TD><TD style="TEXT-ALIGN: center">Mon 03/Jan/11 18:47</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: center">29</TD><TD style="TEXT-ALIGN: center">02/01/2011</TD><TD style="TEXT-ALIGN: center">Mon 03/Jan/11</TD><TD style="TEXT-ALIGN: center">Tue 04/Jan/11 00:01</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: center">31</TD><TD style="TEXT-ALIGN: center">02/01/2011</TD><TD style="TEXT-ALIGN: center">Thu 06/Jan/11</TD><TD style="TEXT-ALIGN: center">Thu 06/Jan/11 16:33</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£15.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: center">30</TD><TD style="TEXT-ALIGN: center">02/01/2011</TD><TD style="TEXT-ALIGN: center">Fri 07/Jan/11</TD><TD style="TEXT-ALIGN: center">Fri 07/Jan/11 15:16</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: center">32</TD><TD style="TEXT-ALIGN: center">02/01/2011</TD><TD style="TEXT-ALIGN: center">Fri 07/Jan/11</TD><TD style="TEXT-ALIGN: center">Fri 07/Jan/11 18:58</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: center">33</TD><TD style="TEXT-ALIGN: center">02/01/2011</TD><TD style="TEXT-ALIGN: center">Sat 08/Jan/11</TD><TD style="TEXT-ALIGN: center">Sat 08/Jan/11 17:34</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: center">36</TD><TD style="TEXT-ALIGN: center">09/01/2011</TD><TD style="TEXT-ALIGN: center">Sun 09/Jan/11</TD><TD style="TEXT-ALIGN: center">Sun 09/Jan/11 17:46</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: center">35</TD><TD style="TEXT-ALIGN: center">09/01/2011</TD><TD style="TEXT-ALIGN: center">Tue 11/Jan/11</TD><TD style="TEXT-ALIGN: center">Tue 11/Jan/11 12:58</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.20</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="TEXT-ALIGN: center">34</TD><TD style="TEXT-ALIGN: center">09/01/2011</TD><TD style="TEXT-ALIGN: center">Wed 12/Jan/11</TD><TD style="TEXT-ALIGN: center">Wed 12/Jan/11 17:13</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="TEXT-ALIGN: center">37</TD><TD style="TEXT-ALIGN: center">09/01/2011</TD><TD style="TEXT-ALIGN: center">Thu 13/Jan/11</TD><TD style="TEXT-ALIGN: center">Thu 13/Jan/11 10:45</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£10.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="TEXT-ALIGN: center">40</TD><TD style="TEXT-ALIGN: center">09/01/2011</TD><TD style="TEXT-ALIGN: center">Thu 13/Jan/11</TD><TD style="TEXT-ALIGN: center">Fri 14/Jan/11 00:00</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="TEXT-ALIGN: center">38</TD><TD style="TEXT-ALIGN: center">09/01/2011</TD><TD style="TEXT-ALIGN: center">Fri 14/Jan/11</TD><TD style="TEXT-ALIGN: center">Fri 14/Jan/11 09:06</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="TEXT-ALIGN: center">39</TD><TD style="TEXT-ALIGN: center">09/01/2011</TD><TD style="TEXT-ALIGN: center">Fri 14/Jan/11</TD><TD style="TEXT-ALIGN: center">Sat 15/Jan/11 00:00</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="TEXT-ALIGN: center">41</TD><TD style="TEXT-ALIGN: center">16/01/2011</TD><TD style="TEXT-ALIGN: center">Sun 16/Jan/11</TD><TD style="TEXT-ALIGN: center">Mon 17/Jan/11 00:00</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="TEXT-ALIGN: center">42</TD><TD style="TEXT-ALIGN: center">16/01/2011</TD><TD style="TEXT-ALIGN: center">Fri 21/Jan/11</TD><TD style="TEXT-ALIGN: center">Fri 21/Jan/11 13:31</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD style="TEXT-ALIGN: center">44</TD><TD style="TEXT-ALIGN: center">16/01/2011</TD><TD style="TEXT-ALIGN: center">Sat 22/Jan/11</TD><TD style="TEXT-ALIGN: center">Sat 22/Jan/11 10:41</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD style="TEXT-ALIGN: center">43</TD><TD style="TEXT-ALIGN: center">16/01/2011</TD><TD style="TEXT-ALIGN: center">Sat 22/Jan/11</TD><TD style="TEXT-ALIGN: center">Sat 22/Jan/11 19:23</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£10.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD style="TEXT-ALIGN: center">47</TD><TD style="TEXT-ALIGN: center">23/01/2011</TD><TD style="TEXT-ALIGN: center">Mon 24/Jan/11</TD><TD style="TEXT-ALIGN: center">Mon 24/Jan/11 09:00</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD style="TEXT-ALIGN: center">45</TD><TD style="TEXT-ALIGN: center">23/01/2011</TD><TD style="TEXT-ALIGN: center">Tue 25/Jan/11</TD><TD style="TEXT-ALIGN: center">Tue 25/Jan/11 16:05</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="TEXT-ALIGN: center">46</TD><TD style="TEXT-ALIGN: center">23/01/2011</TD><TD style="TEXT-ALIGN: center">Wed 26/Jan/11</TD><TD style="TEXT-ALIGN: center">Wed 26/Jan/11 16:29</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: center">48</TD><TD style="TEXT-ALIGN: center">23/01/2011</TD><TD style="TEXT-ALIGN: center">Thu 27/Jan/11</TD><TD style="TEXT-ALIGN: center">Thu 27/Jan/11 13:28</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£15.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="TEXT-ALIGN: center">49</TD><TD style="TEXT-ALIGN: center">23/01/2011</TD><TD style="TEXT-ALIGN: center">Fri 28/Jan/11</TD><TD style="TEXT-ALIGN: center">Fri 28/Jan/11 10:46</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="TEXT-ALIGN: center">50</TD><TD style="TEXT-ALIGN: center">23/01/2011</TD><TD style="TEXT-ALIGN: center">Fri 28/Jan/11</TD><TD style="TEXT-ALIGN: center">Fri 28/Jan/11 18:58</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD style="TEXT-ALIGN: center">52</TD><TD style="TEXT-ALIGN: center">23/01/2011</TD><TD style="TEXT-ALIGN: center">Sat 29/Jan/11</TD><TD style="TEXT-ALIGN: center">Sat 29/Jan/11 18:44</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">44</TD><TD style="TEXT-ALIGN: center">53</TD><TD style="TEXT-ALIGN: center">30/01/2011</TD><TD style="TEXT-ALIGN: center">Sun 30/Jan/11</TD><TD style="TEXT-ALIGN: center">Sun 30/Jan/11 09:14</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">45</TD><TD style="TEXT-ALIGN: center">51</TD><TD style="TEXT-ALIGN: center">30/01/2011</TD><TD style="TEXT-ALIGN: center">Sun 30/Jan/11</TD><TD style="TEXT-ALIGN: center">Sun 30/Jan/11 10:53</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">46</TD><TD style="TEXT-ALIGN: center">59</TD><TD style="TEXT-ALIGN: center">30/01/2011</TD><TD style="TEXT-ALIGN: center">Sun 30/Jan/11</TD><TD style="TEXT-ALIGN: center">Sun 30/Jan/11 19:00</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">47</TD><TD style="TEXT-ALIGN: center">63</TD><TD style="TEXT-ALIGN: center">30/01/2011</TD><TD style="TEXT-ALIGN: center">Tue 01/Feb/11</TD><TD style="TEXT-ALIGN: center">Tue 01/Feb/11 11:37</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">48</TD><TD style="TEXT-ALIGN: center">56</TD><TD style="TEXT-ALIGN: center">30/01/2011</TD><TD style="TEXT-ALIGN: center">Wed 02/Feb/11</TD><TD style="TEXT-ALIGN: center">Wed 02/Feb/11 20:52</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">49</TD><TD style="TEXT-ALIGN: center">58</TD><TD style="TEXT-ALIGN: center">30/01/2011</TD><TD style="TEXT-ALIGN: center">Thu 03/Feb/11</TD><TD style="TEXT-ALIGN: center">Thu 03/Feb/11 15:41</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">50</TD><TD style="TEXT-ALIGN: center">55</TD><TD style="TEXT-ALIGN: center">30/01/2011</TD><TD style="TEXT-ALIGN: center">Fri 04/Feb/11</TD><TD style="TEXT-ALIGN: center">Fri 04/Feb/11 14:32</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£60.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">51</TD><TD style="TEXT-ALIGN: center">57</TD><TD style="TEXT-ALIGN: center">30/01/2011</TD><TD style="TEXT-ALIGN: center">Fri 04/Feb/11</TD><TD style="TEXT-ALIGN: center">Fri 04/Feb/11 14:34</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£60.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">52</TD><TD style="TEXT-ALIGN: center">60</TD><TD style="TEXT-ALIGN: center">30/01/2011</TD><TD style="TEXT-ALIGN: center">Sat 05/Feb/11</TD><TD style="TEXT-ALIGN: center">Sat 05/Feb/11 21:30</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">53</TD><TD style="TEXT-ALIGN: center">54</TD><TD style="TEXT-ALIGN: center">06/02/2011</TD><TD style="TEXT-ALIGN: center">Sun 06/Feb/11</TD><TD style="TEXT-ALIGN: center">Sun 06/Feb/11 12:47</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.40</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">54</TD><TD style="TEXT-ALIGN: center">61</TD><TD style="TEXT-ALIGN: center">06/02/2011</TD><TD style="TEXT-ALIGN: center">Mon 07/Feb/11</TD><TD style="TEXT-ALIGN: center">Mon 07/Feb/11 08:53</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.02</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">55</TD><TD style="TEXT-ALIGN: center">62</TD><TD style="TEXT-ALIGN: center">06/02/2011</TD><TD style="TEXT-ALIGN: center">Wed 09/Feb/11</TD><TD style="TEXT-ALIGN: center">Wed 09/Feb/11 08:59</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.10</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">56</TD><TD style="TEXT-ALIGN: center">65</TD><TD style="TEXT-ALIGN: center">06/02/2011</TD><TD style="TEXT-ALIGN: center">Wed 09/Feb/11</TD><TD style="TEXT-ALIGN: center">Wed 09/Feb/11 18:11</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">57</TD><TD style="TEXT-ALIGN: center">64</TD><TD style="TEXT-ALIGN: center">06/02/2011</TD><TD style="TEXT-ALIGN: center">Thu 10/Feb/11</TD><TD style="TEXT-ALIGN: center">Thu 10/Feb/11 08:55</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">58</TD><TD style="TEXT-ALIGN: center">67</TD><TD style="TEXT-ALIGN: center">06/02/2011</TD><TD style="TEXT-ALIGN: center">Fri 11/Feb/11</TD><TD style="TEXT-ALIGN: center">Fri 11/Feb/11 13:08</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£40.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">59</TD><TD style="TEXT-ALIGN: center">66</TD><TD style="TEXT-ALIGN: center">06/02/2011</TD><TD style="TEXT-ALIGN: center">Sat 12/Feb/11</TD><TD style="TEXT-ALIGN: center">Sat 12/Feb/11 18:00</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£40.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">60</TD><TD style="TEXT-ALIGN: center">68</TD><TD style="TEXT-ALIGN: center">13/02/2011</TD><TD style="TEXT-ALIGN: center">Sun 13/Feb/11</TD><TD style="TEXT-ALIGN: center">Sun 13/Feb/11 19:49</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">61</TD><TD style="TEXT-ALIGN: center">69</TD><TD style="TEXT-ALIGN: center">13/02/2011</TD><TD style="TEXT-ALIGN: center">Mon 14/Feb/11</TD><TD style="TEXT-ALIGN: center">Mon 14/Feb/11 15:18</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£26.98</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">62</TD><TD style="TEXT-ALIGN: center">70</TD><TD style="TEXT-ALIGN: center">13/02/2011</TD><TD style="TEXT-ALIGN: center">Tue 15/Feb/11</TD><TD style="TEXT-ALIGN: center">Tue 15/Feb/11 17:35</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£20.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">63</TD><TD style="TEXT-ALIGN: center">71</TD><TD style="TEXT-ALIGN: center">13/02/2011</TD><TD style="TEXT-ALIGN: center">Thu 17/Feb/11</TD><TD style="TEXT-ALIGN: center">Thu 17/Feb/11 14:46</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£15.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">64</TD><TD style="TEXT-ALIGN: center">72</TD><TD style="TEXT-ALIGN: center">13/02/2011</TD><TD style="TEXT-ALIGN: center">Fri 18/Feb/11</TD><TD style="TEXT-ALIGN: center">Fri 18/Feb/11 14:55</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£40.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">65</TD><TD style="TEXT-ALIGN: center">74</TD><TD style="TEXT-ALIGN: center">13/02/2011</TD><TD style="TEXT-ALIGN: center">Sat 19/Feb/11</TD><TD style="TEXT-ALIGN: center">Sat 19/Feb/11 20:07</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.02</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">66</TD><TD style="TEXT-ALIGN: center">73</TD><TD style="TEXT-ALIGN: center">20/02/2011</TD><TD style="TEXT-ALIGN: center">Mon 21/Feb/11</TD><TD style="TEXT-ALIGN: center">Mon 21/Feb/11 07:01</TD><TD style="TEXT-ALIGN: center">Karen</TD><TD style="TEXT-ALIGN: center">£30.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">67</TD><TD style="TEXT-ALIGN: center">75</TD><TD style="TEXT-ALIGN: center">20/02/2011</TD><TD style="TEXT-ALIGN: center">Mon 21/Feb/11</TD><TD style="TEXT-ALIGN: center">Mon 21/Feb/11 18:22</TD><TD style="TEXT-ALIGN: center">Lee</TD><TD style="TEXT-ALIGN: center">£20.01</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">68</TD><TD style="TEXT-ALIGN: center">76</TD><TD style="TEXT-ALIGN: center">20/02/2011</TD><TD style="TEXT-ALIGN: center">Wed 23/Feb/11</TD><TD style="TEXT-ALIGN: center">Wed 23/Feb/11 16:36</TD><TD style="TEXT-ALIGN: center">Lee</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">69</TD><TD style="TEXT-ALIGN: center">77</TD><TD style="TEXT-ALIGN: center">20/02/2011</TD><TD style="TEXT-ALIGN: center">Thu 24/Feb/11</TD><TD style="TEXT-ALIGN: center">Thu 24/Feb/11 10:00</TD><TD style="TEXT-ALIGN: center">Lee</TD><TD style="TEXT-ALIGN: center">£20.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">70</TD><TD style="TEXT-ALIGN: center">78</TD><TD style="TEXT-ALIGN: center">20/02/2011</TD><TD style="TEXT-ALIGN: center">Fri 25/Feb/11</TD><TD style="TEXT-ALIGN: center">Fri 25/Feb/11 15:55</TD><TD style="TEXT-ALIGN: center">Lee</TD><TD style="TEXT-ALIGN: center">£30.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">71</TD><TD style="TEXT-ALIGN: center">79</TD><TD style="TEXT-ALIGN: center">20/02/2011</TD><TD style="TEXT-ALIGN: center">Sat 26/Feb/11</TD><TD style="TEXT-ALIGN: center">Sat 26/Feb/11 11:28</TD><TD style="TEXT-ALIGN: center">Lee</TD><TD style="TEXT-ALIGN: center">£20.01</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

E
  • Question Question
VBA code clean up
Replies
9
Views
583
mumps
mumps
D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
623
smozgur
smozgur
E
  • Question Question
Adding a custom message.
Replies
1
Views
666
Micron
M
F
  • Question Question
VBA Macro Issue: Replacing Simple Formula with Complex Formula Causes Error
Replies
2
Views
107
flashgordie
F
D
  • Question Question
Looking for a way to allocate shifts between teams, maybe a LET formula
Replies
0
Views
90
Dazzybeeguy
D

Forum statistics

Threads
1,224,602
Messages
6,179,843
Members
452,948
Latest member
UsmanAli786

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