How to pull latest date from a second sheet for a specific item
I'm trying to pull the latest date a certain site has been visited include that in summary sheet from second containing visits data. In secon sheet, specific can have multiple lines corresponding different vists. Any help with formulas do this would be greatly appreciated. Consider it your COVID-19 effort :).
Sheet one columns: Site name; Date of latest visit; etc.
A site has only one row in sheet 1
Sheet 2 columns: Site name; Date of visit; etc.
A site can have multiple rows in sheet 2
Answers
-
Is THIS THREAD the same question? If so, I have responded there. If not, I will be happy to help here as well. Just let me know.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives