"Vinod Lewis" wrote:
Thank you max, this what i wanted.

Welcome. Pl click the Yes buttons (like the ones below), won't you?

If you could explain the formula it would be a great help

Here's some explanation ..

In Sheet2,

Col B is the criteria col. It flags source lines which satisfy the criteria,
ie where the team leader is equal to the name input in A2, with arbitrary row
numbers via ROW(). These arb numbers will then be read by the "float-up"
formulas in col C.

In Col C
SMALL(B:B,ROWS($1:1)) returns the smallest number in col B in the top cell
in C2, the 2nd smallest in C3, and so on. ROWS($1:1) is the incrementer term
used in copying down, it simply returns the numbers: 1,2,3 ... in successive
cells as we copy down.

The returns from SMALL are passed to: INDEX(Sheet1!B:B, ..)
which then retrieves the corresponding names from Sheet1!B:B

The front IF check: IF(ROWS($1:1)COUNT(B:B),"", ...)
ensures that neat looking blanks: "" are returned (instead of ugly #NUM!s)
once all the arb row numbers are exhausted in col C. COUNT(B:B) provides the
threshold here, it returns the count of the number of arb row numbers in col
B.