tbilderbac
New Member
- Joined
- Apr 11, 2022
- Messages
- 28
- Office Version
- 365
- Platform
- Windows
- MacOS
I am have a list of dates and I am trying to extract the last 20 dates and then I want to look at the Diff column numbers [that is associated to the date] and get the average of the 10 lowest differentials out of the last 20 dates.
Date Diff
4/3/2022 24
4/5/2022 19
4/6/2022 23
4/7/2022 24
4/8/2022 26
4/9/2022 25
4/10/2022 28
4/11/2022 21
4/28/2022 19
4/29/2022 24
5/4/2022 15
5/5/2022 16
5/9/2022 30
5/10/2022 26
5/11/2022 25
5/13/2022 24
6/5/2022 19
6/6/2022 21
6/7/2022 20
6/12/2022 26
6/13/2022 21
6/14/2022 24
Date Diff
4/3/2022 24
4/5/2022 19
4/6/2022 23
4/7/2022 24
4/8/2022 26
4/9/2022 25
4/10/2022 28
4/11/2022 21
4/28/2022 19
4/29/2022 24
5/4/2022 15
5/5/2022 16
5/9/2022 30
5/10/2022 26
5/11/2022 25
5/13/2022 24
6/5/2022 19
6/6/2022 21
6/7/2022 20
6/12/2022 26
6/13/2022 21
6/14/2022 24