Hi all,
i have a problem solving this problem, i have the following example data:
Apple Banana Orange
01-10-2022 10 20 5
01-11-2022 12 23 6
01-12-2022 14 24 7
01-01-2023 16 25 8
01-02-2023 18 26 9
01-03-2023 20 27 10
01-04-2023 22 28 11
01-05-2023 24 29 12
01-06-2023 26 30 13
01-07-2023 28 31 14
01-08-2023 30 32 15
I would like 2 have a lookup where i can choose a product and a startdate and number of month and then get a median, something like this:
Example 1
Product Startdate number of months Median
Apple 01-11-2022 3 14
I have tried with median if, but no luck.??
Bookmarks