Hello Again Hui
I've Changed The formula and have got nearly to what I was thinking... But still need help.... Here's the formula I used in the next sheet
=IF(ROW(Sheet3!$A2:$A50)-ROW(Sheet3!$B$50)+1>COUNT(Sheet3!G2:G50),"",INDEX(Sheet3!$A:$A,SMALL(Sheet3!G2:G50,ROW(INDIRECT("1:"&ROWS(Sheet3!B2:B50))))))
Now the problem is that in the column E, All the "Should Be Blanks" cells are showing #NUM! Error...
Another problem, well not actually a problem as long as it works fine, but i want to change all the "Sheet3!$A2:$A50" to a named range.
Thank you for your help