Rank with conditions from two tables

In the attached workbook I am looking to extract the top (smallest) 10 times from 2 separate tables. If it was straight forward it wouldn't be a problem, however the 1st and 2nd ranking must be the top (smallest) 2 times from table 1 where 3rd-10th ranking come from either table. Notice in the attached the 3rd place ranking of 9.13 comes from table 2 and is actually smaller than the 2nd place ranking of 9.27 from table 1. this is probably child's play for the group but it seems to be eluding me this morning.

Thanks

When you say table 1 and table 2, you mean that table 1 is B3:B10 or B3:C10, and table 2 is B12:B19 or B12:B19?

Table 1 - B3:C10
Table 2 - B12:C19

Thanks

Hi

Cell I6 =SMALL($B$3:$C$19,ROWS($A$1:A1)) copy down

kvsrinivasamurthy you guys amaze me with some of these array formulas you come up with..... It worked perfectly and is appreciated.

micope21 Thanks for the formula. I had tried that one but it ignored the fact that the first and second rankings needed to come from one table where the 3rd through 10th could come from either. Check out the array formula that kvsrinivasamurthy uses in his attached workbook. It handles the conditions perfectly.