Shared Documents/Spreadsheets

Hi Alix,

Thank you for the forum question.

Please watch the video to learn how to protect your formulas.

https://www.youtube.com/watch?v=wrOE8fheMR0


About:
b) filtering/sorting on databases with multiple functions.

Do you mean by multiple conditions?

To filter and sort data in Excel by multiple conditions, you can use:

- The AutoFilter feature to filter tables based on values in one or more columns. You can filter using different criteria like numbers, text, dates, and formulas.

- The Advanced Filter feature to filter tables using multiple criteria ranges, showing only rows that meet all specified conditions.

- The Sort feature to sort data in one or more columns, in either ascending or descending order.

- Excel functions like FILTER(), SORT() and SORTBY() to dynamically filter and sort data based on formulas and criteria.

For example, to sort a table by two columns, you can:

```
=SORTBY(A1:B10,B1:B10,A1:A10,TRUE)
```

This will first sort by column B in ascending order, then by column A.

Please provide me with more details about what you want to filter and sort.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector