Macro to find two different text in different column without a loop

[eloirjr]

Hi all,
I'm working in a VBA excel to fix a issue. There is two different column A and B to be checked using different values. Find in column A = Apple and B values >= 1 and return only in which lines is true without loop. Could be possible use sumbproduct to return only the lines that is true, great. So far I cannot solve this issue. Any one have a idea.
Thanks

 

[Joe4]

Use Filters, perhaps?