Extract first value out of column range

[MrFinance1]

Hi,

I am running into an issue that I need your help on. What I'd like to have is retrieving the first value of identical values in one range, see my example range below:

x
y
z
y
z

Now what I want is an index match type of function with which I can select that I want the first ''y'' of this range. Do you guys have any clue?

Thanks a lot

 

[JoeMo]

Excel Workbook
	F	G
1	x	y
2	y
3	z
4	y
5	z
Sheet1

 

[MrFinance1]

thanks, but what if I want to have it with z as well? For example if I have a sheet 2 where I have x, y, z listed and only want to retrieve their first values in line

 

[JoeMo]

thanks, but what if I want to have it with z as well? For example if I have a sheet 2 where I have x, y, z listed and only want to retrieve their first values in line

What is "it"? You asked for the first value that has multiple instances in the range - that's what I addressed.

 

[MrFinance1]

What I mean there is when you have a list of names with corresponding %'s such as below and you have double names, such as Tom and Joe, how to get the first % that belongs to the respective name. How to quickly do this in a formula? Because an Index Match would recognize both names and as such not a clean way to do this.

Tom 0.5%
Joe 0.25%
Brad 0.25%
Bill 0.35%
Charlie 0.26%
Tom 0.6%
Joe 0.30%