The file has a list of addresses and each address may appear several times with different dates. The address row for each property also includes number of bedrooms. Most properties have between 1 and 6 bedrooms.
The objective is to ignore the dates, de-dupe the list then count the number of properties by number of bedrooms. Then calculate the total number of bedrooms.
The example file contains examples of the three lists. Suburbs--Properties-Bedrooms2014.xlsx
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.