1, no problem with the formula. I don't know if the quantity is large. If the quantity is not large, it is ok. If the quantity is large, the running speed will be slow.
2. It can be achieved by constantly filtering and pasting.
3. It can be realized by using the PivotTable report.
Please email me for details.