I have several HLookUp formulas and need them not to repeat the result from above

[zoedc3]

I am creating an overtime sheet for employees A - K. Each employee will add their overtime below and their total worked is added at the top for a running total. Management needs a call in list that provides the employee names, with least amount of hours worked to most, with no repeats.

In my case, there are multiple employees with no over time worked. The one with the most seniority (furthest to the left) is called first, but I need it to provide the next four employees afterwards with no overtime worked in the list as well.

I have attached a sample of what I am working on.

[azumi]

Hope this helps

[Pete_UK]

You can put this array* formula in N2:

=INDEX($B$3:$L$3,SMALL(IF($B$2:$L$2=M2,COLUMN($B:$L)-1),COUNTIF(M$2:M2,M2)))

then copy down.

*Note that an array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE) instead of the usual < Enter >.

Hope this helps.

Pete

[AliGW]

Azumi - not for the first time, I am drawing your attention to this:

Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

Please do not continue to ignore this request, Thank you.

[José Augusto]

Hi

With a normal formula and no helper column

Try this in N2 e drag down.

Please Login or Register  to view this content.

See the attached file

[zoedc3]

Thank you PETE_UK your formula worked.

I was having issues with the If statement part of this!