Copy cell content from row with latest date
Closed
zoran
-
28 Apr 2011 à 15:00
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 29 Apr 2011 à 01:10
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 29 Apr 2011 à 01:10
Related:
- Copy cell content from row with latest date
- Fifa 23 downloadable content - Download - Sports
- Saints row 2 cheats - Guide
- Summertime saga downloadable content - Download - Adult games
- Efootball 2022 downloadable content - Download - Sports
- How to delete a row in word - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
29 Apr 2011 à 01:10
29 Apr 2011 à 01:10
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)
