I have a list of team members numbers in one column and their corrosponding
team numbers in another column. I would like display the teams seperately on
other sheets automatically. I would like a formula that will search the first
sheet, identify all team 1 members for example, and sort them numerically on
a seperate team sheet. Previously, someone gave me this formula but I can't
get it to work:
=INDEX(S7:S18,SMALL(IF(U7:U18=I2,ROW(S7:S18),ROW(1 :1)),1)) (at this point,
this is just a tester, so doesn't actually point to a different sheet)
any tips would be appreciated,
Robert