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", "Sentinel Event".
The data automatically goes to sheet1 via form responses, but I am trying to streamline the data into specific types of events. I'm using office 365.
TIA!
1 Reply
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.
