Copy cell content from row with latest date

Closed
zoran - Apr 28, 2011 at 03:00 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 29, 2011 at 01:10 AM
Hello,
please, can somebody help me how to get the copy of data from row which have the latest date to different table on another sheet.
Namely I my table have columns:
Date; Sale on date; Monthly plan; ...
and I want to automatically copy the latest Date and Sale on date to another sheet.
Thanks in advance.


1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Apr 29, 2011 at 01:10 AM
suppose data and sale date from A1 to B down
row 1 has column headings

date sale
1/5/2011 1
3/7/2011 2
4/17/2011 3
4/28/2011 4




in sheet 2 in any empty cell e.g. A1 type this formula

=MAX(Sheet1!$A$2:$A$100)

assuming there less than 100 rows in sheet

in the next cell namely B1 type this formula

=VLOOKUP(A1,Sheet1!$A$1:$B$100,2,0)
0