Hi,
I am moving away from Google Suite and to using 360 and so am in the process of moving all my google sheets to excel. In the most part it has been simple (especially with the help of people on here) with a few formula adjustments but I've come unstuck with the query function.
Ill start at the beginning.
I have a large sheet with evaluation data. There is a question where delegates are asked to write comments.
I would like to sort the data so in another sheet only the comments that have been made on each row that both relate to a particular trainer (named in column V:V) and within a date range or particular month (Column R:R) are displayed.
in google sheets (I was able to use =query(Exported!$V$1:$AV$998,"select AJ where V = 'Trainer Name'") although admittedly I hadn't worked out how to also filter by month.
Any ideas of how I can replicate this so i can basically sort the data automatically by Month and Trainer name
Bookmarks