Hello, I am looking to get some thing built in excel if possible. The file attached shows rental units in Calgary. I am looking for a average broken down by the following:
a count of how many listing were used for the average
Type of home
sq footage within + or - 200
For example if there is a listing in Calgary in the same quadrant and community that is a house 1800 sq feet with 3 bedrooms and 2 bathrooms and one is listed for 2000 and the other listed for 2200 the average rent for that area for a house that size is 2100. If the home was more than 200 sq bigger or a different type of home or area then it can not be averaged as it considerably bigger and in a different location or type.
I would like to have a excel sheet where I can copy and paste the same data I attached to get the averages when I need to.
15 freelancers are bidding on average $349 for this job
Hi, I can provide such sheet where you just put raw data in one of sheet and all tables all refresh in other columns with various category need and in future also can add more tables there....thanks!!
I am working at excel automation and VBA programming at HSBC Paris. I can Help you extract averages you want within 10 to 20 Hours of work. I hope we can work together. Kind regards. Adrien