I have excel sheet with two columns (Employee Name and Technology).I need formula to filter data on technology column,instead of manually applying filter and sorting the data.

Is there any formula which gives me the result to find out the employee name based on technology.

(Example:If i want to find out the employee who have oracle and BI,after applying the formula i should have excel data with Tom,Dave and Robert)

Employee Name Technology

Tom Oracle
Robert BI
Nick MSBI
Dave Oracle


Thank you.