Hi all,

I'd like to seek your help regarding referencing third party cells based on the behaviour of other cells, and within a table.

1. In the "address" column, if an "address" matches another "address"

2. Ask excel to look at the contract date of the transactions

3. Ask excel to find out the "unit price" of the respective transactions and take the (unit price of later transaction) / ( unit price of earlier transaction)

There are a few more detailed questions in the attachment itself and I'm very grateful to anyone who can help me with this!! Thanks

Book3.xlsx