Formula to return more than one value - Please help!!!!!

Formula to return more than one value - Please help!!!!!

=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)))

Capture.PNG

Tagged:

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

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

Sign In or Register to comment.