SQL Select statement in Excel

Occasional Visitor

Hi I have a huge excel workbook with clinical trial data, I need to pull all rows with a specific trial ID for my analysis 


In SQL we write it as 

Select *


Where Trial ID = "1234"


but how to do it on excel

1 Reply


Let's say the data are on Sheet 1 in A2:W1000, with Trial ID in column D.

On another sheet, enter the following formula in A2:

=FILTER(A2:W1000,D2:D1000="1234","No Data")