Penni
New member
- Joined
- Mar 13, 2020
- Messages
- 5
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
I am looking for a data set that shows multiple species across all sites but with only the record for each species on a site with the most recent survey year. My data set has "Sites" for which there are multiple entries (Survey Date) for multiple plant species (Species), in some cases. What I want to do is return a dataset that has Site with all Species for Site but only the most recent Survey Year.
I've attached a small raw data set (I have 1,000s of records) along with a mini example of what I want to see in results.
I've attached a small raw data set (I have 1,000s of records) along with a mini example of what I want to see in results.