Oct 26 2021 05:57 AM - edited Oct 26 2021 06:45 AM
Trying to do top middle and bottom averages with a condition.
I have rents of differens areas and want to create a conditional average rent based on the area. Other than that I would also want to make the rent in low, middle and top averages to show the different levels in each area. Please check the attached filed as example.
Many thanks
Oct 26 2021 07:09 AM
@Benwi123 I believe you need to define first what is High, Medium and Low. Add a column to the table and create a pivot table on that one. See attached. Is that something you are after?
Oct 26 2021 07:31 AM
Oct 26 2021 08:11 AM
@Benwi123 Understand, but statistics is not my speciality and I'm not really up to speed on how to create such a normal distribution in Excel.
Oct 26 2021 08:32 AM