Forum Discussion
SQL Select statement in Excel
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 = "12...
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")
