Forum Discussion
Help with Excel Sorting
Hello! I am looking for help with sorting data on a sheet with form responses to different excel sheets. I want to filter by column G to different sheets ("Near Miss", "Adverse Event", "Sentine...
You need FILTER() function like-
=FILTER(Sheet1!A2:K1000,Sheet1!G2:G1000="Near Miss","")You need same formula for other sheets but change criteria text.