Excel Workpaper Creation & Formula Assistance

I'm seeking an Excel expert to help fix a workpaper i've created for tracking shares and assisting with necessary formulas. The workpaper's primary purpose will be ongoing tracking of shares.

Key Requirements:
- Strong Excel formula

Skills Needed:
- Advanced Excel skills
- Knowledge in financial analysis
- Experience with 'if', 'lookup', and 'sum' functions
- Ability to create a comprehensive workpaper for tracking shares.

Intention
Column B to N are manual inputs. They will consist of the following
- B - Date of shares originally purchased
- C - Name of shares purchased
- D - If the shares were bought or sold
- E to M - Cost base application (to help with formulas in other columns)
- L - Total number of shares purchased
- M - Total dolalr value of shares purchased
- N - Hyper link section for reference

Column P to T are the sections I need assistance with.
- P - Picking up date of all shares that are not sold from column B
- Q - Picking up name shares that are not sold from column C
- R -
- S - Total amount of shares still on hand after all cost base have been applied
- T - Total dollar value still on hand after all cost base have been applied

Column V to X is just a summary of each company shares and total dollar value

Use Mineral Resources as an example - Total shares purchased were 526. Then 85 were sold. I need to apply the 85 shares sold against the 526 shares purchased to show 441 shares remaining and the total dollar value is 441 times (526/19976.06).

The difficult part is Castillo Copper which needs to show the remaining shares being 0. But I'm not sure how to apply this.

I can provide more information over a loom video if need be.