I have recently bought the book VLookup book by chandoo and i have some problem on how i can get the last or final occurance, at the moment i can set the
occurance by setting the numbers but how do i get the last occurance?
This is the current formula where the number 2 at the end will show the 2nd occurance, but i don't know how to get the last occurance
=INDEX($E$5:$E$17, SMALL(IF ($C$5:$C$17="JOHN", ROW($C$5:$C$17)-ROW($C4)), 2))
Also is there a way to alter the formula to show:
1. the occurance when its value matches a condition
many thanks
occurance by setting the numbers but how do i get the last occurance?
This is the current formula where the number 2 at the end will show the 2nd occurance, but i don't know how to get the last occurance
=INDEX($E$5:$E$17, SMALL(IF ($C$5:$C$17="JOHN", ROW($C$5:$C$17)-ROW($C4)), 2))
Also is there a way to alter the formula to show:
1. the occurance when its value matches a condition
many thanks