wizardmagu
Board Regular
- Joined
- Dec 27, 2012
- Messages
- 58
- Office Version
- 365
- Platform
- Windows
I have a file that I use and have a formula to find the most recent "Effective Date" based on the text in the "Header" column. The issue I have is that column B "Resource" is also unique and in the past I would filter the sheet and paste each resource to its own tab. I'm sure these is a way to get this done while all in the same sheet... Any thoughts on changing my current formula to also use column B as a requirement for a match