Dynamic Median to figure out the best medianintervall

Hallo Stefan,

schreibe in F1 die Startzeile und in F2 die Anzahl Zeilen, die berechnet werden sollen und probiere es dann so:

=MEDIAN(BEREICH.VERSCHIEBEN(INDIREKT("B"&F1);;;F2))

Claus

Thanks for a swift and helpful reply.
<br />It was an add-in. Now I will have to figure out 1. which one and 2. try to remove it (not as easy as it sounds).

<br />

Yes, it is possible to create dynamic filters for a SharePoint list view that will automatically update the calendar view to show only the items that meet the filter criteria. You can do this by using the Filter option in the list view settings.
To create a dynamic filter for your list view, follow these steps:

1. Open the list in SharePoint and switch to the view you want to filter.
2. Click on the gear icon in the top right corner of the page and select “List settings” from the drop-down menu.
3. Scroll down to the “Views” section and click on the name of the view you want to filter.
4. In the “Filter” section, select “Show items only when the following is true” and set up your filter criteria using the available fields and operators.
5. Click “OK” to save your changes.
   

Once you’ve set up your dynamic filter, the calendar view will automatically update to show only the items that meet your filter criteria. You can change or remove the filter at any time by going back to the list view settings and modifying your filter criteria.

The Outlook Team rolled out a fix to the service over the weekend. The issue should now be resolved.

Thanks for your answer but I am not sure to sign out at my mobile device because there it comes the message that the not synchronized data will get lost in case I sign out.
<br />