Copy cell content from row with latest date
Closed
zoran
-
Apr 28, 2011 at 03:00 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 29, 2011 at 01:10 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 29, 2011 at 01:10 AM
Related:
- Copy cell content from row with latest date
- Efootball 2022 downloadable content - Download - Sports
- Need for speed: most wanted 2005 downloadable content - Download - Racing
- Summertime saga downloadable content - Download - Adult games
- Ultimate custom night downloadable content - Download - Horror
- Mobile legends: bang bang vng downloadable content - Download - MOBA
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Apr 29, 2011 at 01:10 AM
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)
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)
