Anyone know a formula that exists for this?

So for first employee (15656366) codes would be) H, E and A ??

If so, employee occurrence is maximum of 3?

Or am I going completely in wrong direction?

Can you post example of expected result for first employee?

Hi John

Thank you for replying. In the sample data provided, yes, the maximum occurrence is 3 times. However in my official spreadsheet employees can appear up to 13 times in the list. I figured it would be easier to provide a smaller sample and then expand the formula in my real data afterwards.

I've updated the image provided so hopefully this answers your last question.

Any help would be appreciated

Cheers

Sorry but I cannot view the image. And need to clearly to understand the logic of getting the codes (with more than 3 occurrences of an employee).

Can you add examples to the sample file INCLUDING >3 occurrences of an employee.

Hi John, I've attached a v2 of the example data to this post.

I've manually typed what I would want the formula to bring back into the first few rows on the spreadsheet.

Hope this helps! Let me know if you need anything else or are having trouble viewing.

Thanks again!

Harry

Hi

Yeah - I'd like it to bring back all 13 different codes. Haha, I'm starting to think I might be over-complicating this by going the wrong way about achieving my end result, but this way originally seemed easier to explain. This formula query only part of the overall process in which I need to figure out. I didn't want to post the whole thing on here, as it would probably be very hard to answer. Do you think it would be worth doing that though? Then linking this thread to it?

Thanks for the help and time so far!

ps - I believe 13 was the maximum number of times each employee number would appear, but if there was for example 14 appearances then I would add another column and drag the formula out (or update the references).

Harry

In D2

=IFERROR(INDEX($B$2:$B$200,SMALL(IF($A$2:$A$200=$A2,ROW($A$2:$A$200)-ROW($A$2)+1,""),COLUMNS($D:D)))," ")

Enter with Ctrl+Shilft+Enter

Drag across and down

Hi

That worked perfectly! Many thanks!! I still find it hard getting my head around the =SMALL function but I'll look into it more as it seems useful.

I will create a workbook with sample data and try and best explain what I'm trying to achieve. I did not expect a perfect result so quickly so you've caught me off guard! Haha!

I am about to leave work for the day but will prepare the relevant information tomorrow morning and upload it with my next reply.

Thanks again for your time and perfect solution to my query!

Also thanks, John! You guys are great.

Cheers

Harry