I have one table filled with customer data. Some examples:
- date of last contact
- gender
- ...
Now I want to create a new table where only male customers are shown, ordered by the date of the last contact.
Is there a build in function to achieve data aggregation in this way or do I have to write a script? It occurs to me that there has to be some built-in way because I think it's a common task to evaluate data in this way.
copy -> paste special -> values
to new sheets or you can use the camera tool to take screen shots of the tables. Also, if they work for you come back and let me know so I can "answer" the question properly