SQL Select statement in Excel

[Reddypk]

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 *

From XXXTABLE

Where Trial ID = "1234"

but how to do it on excel

[#2]

@Reddypk 

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")