Find based on lowest occurance and condition, then ditribute evenly.

Hello and welcome to the forum.

However it only matches if BOTH conditions are exaclty met on the first occurence.

Which both conditions... you are only checking MIN there ? suggest you to provide your expected results and the logic and I'll be happy to give a try. thanks.

Regards,
DILIPandey
<click on below * if this helps>

Thanks for taking the time. It's difficult to explain

This is what want to achieve. In "column K" I want to display the name in the list with the least occurencies. Meaning, I check to find the name with least occurences in column K, and when I find that one, I check if he/she is availiable at the time specified in Column J. If he/she is not availiable, find the one with second least occurences and see of he/she is availiable at the specified time. If he is, display it, if not. keep searching... Etc..

I tried

{=INDEX($A$2:$A$10;MATCH($J4;IF($F$3:$F$10=MIN($F$3:$F$10);$C$3:$C$10);0))}

but that'll only find one result and if it doesn't match on both conditions it fails. Also it will not work because of circular reference.

If not possible to do this with standard formulas, I'm willing to make a macro or custon function for it. But I'm not that great in VB...

I updated the file to see the condition i action.
testingSched2.xlsx