Hello Experts. So I am kind of an average Matlab User, mostly used to command line stuff. I got a task in Excel and as a newbie I post my query here. In the attachment you find a example database of power units within a single European country. I would like cluster the power units per country based on
1. unit type and in this cluster class
a. find and deleted the units that stopped e.g in and before 2010.
b. then the number of installed units,
c. the sum of the unit capacities and
c. the average of the unit efficiency.
Manually I was able to do it on the same sheet but for a large database I prefer a solution in excel which is updating itself may be on another sheet, when a change in the database occurs.
I shall be thankful for any comments.