Nth occurrence

[Bugas]

Hi!

My table looks this:


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]x[/TD]
[TD]y[/TD]
[TD]z[/TD]
[TD]aa[/TD]
[TD]ab[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]Client[/TD]
[TD]Jan-12[/TD]
[TD]Fev-12[/TD]
[TD]Mar-12[/TD]
[TD]Apr-12[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]aaa[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]bbb[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]103[/TD]
[TD]ccc[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]104[/TD]
[TD]ddd[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]105[/TD]
[TD]eee[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]106[/TD]
[TD]fff[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]107[/TD]
[TD]ggg[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]108[/TD]
[TD]hhh[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]


For Jan-12 I would get this information:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jan-12[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]aaa[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ccc[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]bbb[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]ddd[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]eee[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]fff[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]ggg[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]hhh[/TD]
[/TR]
</tbody>[/TABLE]


I'm trying to get the second, third, ... occurrence. It's not starting on A1. When I use vlookup, I only get the first occurance, ignoring the 2nd or the 3rd. I

I want to use excel formula.

 

[Bugas]

Thanks everyone! Works perfect

 

[Robert Mika]

Thanks everyone! Works perfect

You are welcome.Apprecieate the feedback.