Extracting the most recent date - No CSE

G

GK039

Board Regular
Joined
Oct 29, 2010
Messages
225
Office Version
  1. 365
Platform
  1. Windows
Hi all,

I have a data set resembling the example below. I want to extract the most recent date for a person in colB. I use the following array formula

=INDEX($C$3:$C$51,SMALL(IF($B$3:$B$51=G2,ROW($B$3:$B$51)-ROW(B3)+1),SUMPRODUCT(--($B$3:$B$51=G2))))

where G2 is a data valisation list with the names in ColB. In the example cell G2 houses the value of Surname9 Name9 and the result is the last date in row 48.

I was wondering if there is a way to achieve this without using array formula.

Thanks in advance

George

Returning Largest Date


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Tahoma,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 39px"><COL style="WIDTH: 160px"><COL style="WIDTH: 146px"><COL style="WIDTH: 79px"><COL style="WIDTH: 74px"></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></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">ID</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">Surname</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">Salary Raise Date</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">Branch</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-WEIGHT: bold">Salary</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right">12</TD><TD>Surname1 Name1</TD><TD style="TEXT-ALIGN: right">11/19/2003</TD><TD>Branch7</TD><TD style="TEXT-ALIGN: left">456.98</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right">14</TD><TD>Surname2 Name2</TD><TD style="TEXT-ALIGN: right">12/1/2003</TD><TD>Branch5</TD><TD style="TEXT-ALIGN: left">718.30</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">15</TD><TD>Surname3 Name3</TD><TD style="TEXT-ALIGN: right">10/20/2003</TD><TD>Branch7</TD><TD style="TEXT-ALIGN: left">588.30</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right">16</TD><TD>Surname4 Name4</TD><TD style="TEXT-ALIGN: right">11/20/2003</TD><TD>Branch6</TD><TD style="TEXT-ALIGN: left">685.25</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right">14</TD><TD>Surname2 Name2</TD><TD style="TEXT-ALIGN: right">11/24/2003</TD><TD>Branch9</TD><TD style="TEXT-ALIGN: left">698.25</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">12</TD><TD>Surname1 Name1</TD><TD style="TEXT-ALIGN: right">3/12/2004</TD><TD>Branch1</TD><TD style="TEXT-ALIGN: left">695.20</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right">11</TD><TD>Surname5 Name5</TD><TD style="TEXT-ALIGN: right">10/1/2003</TD><TD>Branch4</TD><TD style="TEXT-ALIGN: left">593.80</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: right">75</TD><TD>Surname6 Name6</TD><TD style="TEXT-ALIGN: right">11/1/2003</TD><TD>Branch4</TD><TD style="TEXT-ALIGN: left">763.90</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right">112</TD><TD>Surname7 Name7</TD><TD style="TEXT-ALIGN: right">11/6/2003</TD><TD>Branch7</TD><TD style="TEXT-ALIGN: left">715.21</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right">75</TD><TD>Surname8 Name8</TD><TD style="TEXT-ALIGN: right">11/3/2003</TD><TD>Branch5</TD><TD style="TEXT-ALIGN: left">798.25</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: right">12</TD><TD>Surname1 Name1</TD><TD style="TEXT-ALIGN: right">15/6/2004</TD><TD>Branch1</TD><TD style="TEXT-ALIGN: left">703.23</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: right">75</TD><TD>Surname8 Name8</TD><TD style="TEXT-ALIGN: right">24/4/2003</TD><TD>Branch8</TD><TD style="TEXT-ALIGN: left">884.12</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: right">75</TD><TD>Surname6 Name6</TD><TD style="TEXT-ALIGN: right">10/27/2005</TD><TD>Branch9</TD><TD style="TEXT-ALIGN: left">698.47</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: right">14</TD><TD>Surname2 Name2</TD><TD style="TEXT-ALIGN: right">12/1/2004</TD><TD>Branch6</TD><TD style="TEXT-ALIGN: left">915.50</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: right">75</TD><TD>Surname8 Name8</TD><TD style="TEXT-ALIGN: right">10/27/2006</TD><TD>Branch5</TD><TD style="TEXT-ALIGN: left">881.10</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000">177</TD><TD>Surname9 Name9</TD><TD style="TEXT-ALIGN: right">12/1/2003</TD><TD>Branch5</TD><TD style="TEXT-ALIGN: left">824.56</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: right">75</TD><TD>Surname6 Name6</TD><TD style="TEXT-ALIGN: right">11/13/2006</TD><TD>Branch3</TD><TD style="TEXT-ALIGN: left">698.68</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: right">12</TD><TD>Surname10 Name10</TD><TD style="TEXT-ALIGN: right">10/1/2003</TD><TD>Branch5</TD><TD style="TEXT-ALIGN: left">689.25</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: right">75</TD><TD>Surname6 Name6</TD><TD style="TEXT-ALIGN: right">11/20/2007</TD><TD>Branch2</TD><TD style="TEXT-ALIGN: left">658.25</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: right">12</TD><TD>Surname1 Name1</TD><TD style="TEXT-ALIGN: right">10/16/2005</TD><TD>Branch5</TD><TD style="TEXT-ALIGN: left">712.34</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: right">112</TD><TD>Surname7 Name7</TD><TD style="TEXT-ALIGN: right">10/8/2004</TD><TD>Branch1</TD><TD style="TEXT-ALIGN: left">698.65</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: right">75</TD><TD>Surname6 Name6</TD><TD style="TEXT-ALIGN: right">10/1/2008</TD><TD>Branch5</TD><TD style="TEXT-ALIGN: left">702.44</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: right">14</TD><TD>Surname2 Name2</TD><TD style="TEXT-ALIGN: right">11/10/2005</TD><TD>Branch9</TD><TD style="TEXT-ALIGN: left">411.50</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: right">75</TD><TD>Surname8 Name8</TD><TD style="TEXT-ALIGN: right">11/24/2008</TD><TD>Branch7</TD><TD style="TEXT-ALIGN: left">527.40</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: right">15</TD><TD>Surname3 Name3</TD><TD style="TEXT-ALIGN: right">11/13/2005</TD><TD>Branch6</TD><TD style="TEXT-ALIGN: left">985.00</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="TEXT-ALIGN: right">112</TD><TD>Surname7 Name7</TD><TD style="TEXT-ALIGN: right">11/18/2005</TD><TD>Branch9</TD><TD style="TEXT-ALIGN: left">752.20</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="TEXT-ALIGN: right">75</TD><TD>Surname6 Name6</TD><TD style="TEXT-ALIGN: right">11/18/2009</TD><TD>Branch7</TD><TD style="TEXT-ALIGN: left">755.68</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000">177</TD><TD>Surname9 Name9</TD><TD style="TEXT-ALIGN: right">10/8/2005</TD><TD>Branch3</TD><TD style="TEXT-ALIGN: left">778.10</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="TEXT-ALIGN: right">15</TD><TD>Surname3 Name3</TD><TD style="TEXT-ALIGN: right">10/27/2006</TD><TD>Branch2</TD><TD style="TEXT-ALIGN: left">701.00</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="TEXT-ALIGN: right">112</TD><TD>Surname7 Name7</TD><TD style="TEXT-ALIGN: right">10/27/2006</TD><TD>Branch1</TD><TD style="TEXT-ALIGN: left">725.29</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="TEXT-ALIGN: right">11</TD><TD>Surname5 Name5</TD><TD style="TEXT-ALIGN: right">10/15/2003</TD><TD>Branch7</TD><TD style="TEXT-ALIGN: left">746.40</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="TEXT-ALIGN: right">12</TD><TD>Surname10 Name10</TD><TD style="TEXT-ALIGN: right">10/15/2003</TD><TD>Branch4</TD><TD style="TEXT-ALIGN: left">769.00</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD style="TEXT-ALIGN: right">11</TD><TD>Surname5 Name5</TD><TD style="TEXT-ALIGN: right">11/24/2004</TD><TD>Branch5</TD><TD style="TEXT-ALIGN: left">852.12</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000">177</TD><TD>Surname9 Name9</TD><TD style="TEXT-ALIGN: right">10/20/2006</TD><TD>Branch8</TD><TD style="TEXT-ALIGN: left">529.10</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD style="TEXT-ALIGN: right">112</TD><TD>Surname7 Name7</TD><TD style="TEXT-ALIGN: right">10/15/2007</TD><TD>Branch7</TD><TD style="TEXT-ALIGN: left">825.35</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD style="TEXT-ALIGN: right">12</TD><TD>Surname10 Name10</TD><TD style="TEXT-ALIGN: right">11/6/2004</TD><TD>Branch2</TD><TD style="TEXT-ALIGN: left">785.24</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000">177</TD><TD>Surname9 Name9</TD><TD style="TEXT-ALIGN: right">11/25/2007</TD><TD>Branch6</TD><TD style="TEXT-ALIGN: left">863.30</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: right">12</TD><TD>Surname1 Name1</TD><TD style="TEXT-ALIGN: right">12/4/2006</TD><TD>Branch2</TD><TD style="TEXT-ALIGN: left">867.23</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="TEXT-ALIGN: right">12</TD><TD>Surname10 Name10</TD><TD style="TEXT-ALIGN: right">10/27/2005</TD><TD>Branch6</TD><TD style="TEXT-ALIGN: left">765.48</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="TEXT-ALIGN: right">11</TD><TD>Surname5 Name5</TD><TD style="TEXT-ALIGN: right">11/24/2005</TD><TD>Branch9</TD><TD style="TEXT-ALIGN: left">874.32</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD style="TEXT-ALIGN: right">11</TD><TD>Surname5 Name5</TD><TD style="TEXT-ALIGN: right">11/3/2006</TD><TD>Branch8</TD><TD style="TEXT-ALIGN: left">958.25</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">44</TD><TD style="TEXT-ALIGN: right">75</TD><TD>Surname6 Name6</TD><TD style="TEXT-ALIGN: right">11/11/2010</TD><TD>Branch6</TD><TD style="TEXT-ALIGN: left">658.21</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">45</TD><TD style="TEXT-ALIGN: right">12</TD><TD>Surname10 Name10</TD><TD style="TEXT-ALIGN: right">11/5/2005</TD><TD>Branch5</TD><TD style="TEXT-ALIGN: left">495.00</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">46</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000">177</TD><TD>Surname9 Name9</TD><TD style="TEXT-ALIGN: right">11/5/2008</TD><TD>Branch3</TD><TD style="TEXT-ALIGN: left">752.24</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">47</TD><TD style="TEXT-ALIGN: right">112</TD><TD>Surname7 Name7</TD><TD style="TEXT-ALIGN: right">10/27/2008</TD><TD>Branch4</TD><TD style="TEXT-ALIGN: left">824.63</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">48</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ff0000">177</TD><TD>Surname9 Name9</TD><TD style="TEXT-ALIGN: right">11/3/2009</TD><TD>Branch6</TD><TD style="TEXT-ALIGN: left">1,024.18</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">49</TD><TD style="TEXT-ALIGN: right">11</TD><TD>Surname5 Name5</TD><TD style="TEXT-ALIGN: right">11/3/2008</TD><TD>Branch2</TD><TD style="TEXT-ALIGN: left">911.20</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">50</TD><TD style="TEXT-ALIGN: right">112</TD><TD>Surname7 Name7</TD><TD style="TEXT-ALIGN: right">11/10/2009</TD><TD>Branch1</TD><TD style="TEXT-ALIGN: left">654.00</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">51</TD><TD style="TEXT-ALIGN: right">14</TD><TD>Surname2 Name2</TD><TD style="TEXT-ALIGN: right">10/15/2006</TD><TD>Branch1</TD><TD style="TEXT-ALIGN: left">897.68</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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Sort by date Sort by votes
Perhaps

=INDEX($C$3:$C$51,LARGE(INDEX(($B$3:$B$51=G2) * (ROW($B$3:$B$51)-ROW(B3)+1), 0), 1))
 
Upvote 0
G1: Surname

G2: Surname9 Name9

Format G1 as bold & italic with borders around.

G3, just enter...

=DMAX(A2:E51,3,$G$1:$G$2)
 
Upvote 0
Thank you both. They both work perfectly. I will use Aladin's alternative as i think it will be easier to explain to those who will use the workbook.

A question regarding shq's reply. Can you explain me the use of the zero in the second INDEX bit (i.e: the row argument)

Thanks again!

George
 
Upvote 0
Much nicer, Aladin.

@GK: A value of zero in the row index specifies all rows of a 2D array for a specified column, or all elements of a 1D (row or column) array.
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
617
smozgur
smozgur
E
  • Question Question
VBA code clean up
Replies
9
Views
573
mumps
mumps
E
  • Question Question
Adding a custom message.
Replies
1
Views
659
Micron
M
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
V
  • Question Question
Issue with scraping with VBA
Replies
1
Views
692
John_w
J

Forum statistics

Threads
1,224,521
Messages
6,179,286
Members
452,902
Latest member
Knuddeluff

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