krokodilizm
New Member
- Joined
- Feb 3, 2016
- Messages
- 20
I have the below problem analyzing a bank movement
I want to filter out all JOHN payments but as you can see the amount is out of sync with the term 'john' by 6 rows. This pattern is consistent throughout the spreadsheet. How can I quickly filter all John payments?
I was thinking some sort of vlookup function with rows offset by 6, but how?
Thanks
I want to filter out all JOHN payments but as you can see the amount is out of sync with the term 'john' by 6 rows. This pattern is consistent throughout the spreadsheet. How can I quickly filter all John payments?
I was thinking some sort of vlookup function with rows offset by 6, but how?
Thanks