Hi guys,
I know there are a few ways to return the nth value that is found. Such as, using array formula (small, row, if combination), or add a help column (countif).
But I am thinking it will make work lot easier if we can create a Vlookup function that can return the 2nd, 3rd.... nth value list (shown on columns on the right).
Here is what I want to achieve:
Source data:
A 1
B 2
C 3
B 4
C 5
D 6
Goal:
A 1
B 2 4
C 3 5
I tried the following but not completed:
Please Login or Register to view this content.
Bookmarks