Hi,
this is possible to solve via "MS Query", which is built-in in Excel. It is not too easy to explain. I attach a sheet that should work for you. You can add your data to this sheet!
Do not change anything in the sheet "Result". Try to change records in the sheet "Data" and you will see that the "result" sheet changes!
Kind regards
Bjorn
|