1

=INDEX([Job Name]1:[Job Name]15, SMALL(IF([Job Number]22=[Job Number]1:[Job Number]15, ROW([Job Number]1:[Job Number]15)-ROW([Job Number]1)+1), ROW(1:1)))

Functionality

Comments

I'm not sure I follow. What exactly are you trying to accomplish? Can you provide more details?