Hi there



I have a specific problem.

I have two worksheets, each with vertically arranged data in three columns. For example sheet 1 = A – b – 5 / B – b – 3 / C – a – 6.5 and sheet 2 = D – a – 4 / E – b – 7 / F – f – 8. Into the third worksheet I wish to extract data from columns A and B of sheets 1 and 2 but only those that are accompanied by a value equal to or above 6.
In other words, if there was such a function I would see in columns A and B in the third worksheet C – a / E – b and F – f.
Can I do this in Excel?

Thanks for your help