oruekelvin
New Member
Hi guys
Please i need your help urgently. I applied for a job and received the task below to be completed as at yesterday. After submission, the employer stated i was suppose to use a Matrix Formula for the assignment. I have never used the matrix or array formula before this is a problem for me at the moment.
PLEASE i need an assistance, please!!!
Exercise 1
One of our contractors has wrongly saved transactions that need to be cancelled/deleted. He has provided a list of all transactions in tab "Transactions 1".
We have also listet all our transactions in tab "Transactions 2" and marked the ones that need to be cancelled/deleted in the database of our contractor.
Please mark all transactions in tab "Transactions 1" with YES or NO in column G that should be cancelled/deleted according to the list given in "Transactions 2".
Exercise 2
In tab "Transactions 3" please list all transactions from tab "Transactions 2" that need to be cancelled/deleted in rows directly underneath each other.
Important:
For both exercises do not change or sort the lists under tabs "Transaction 1" and "Transaction 2". However, feel free to add additional columns wherever needed.
Please i need your help urgently. I applied for a job and received the task below to be completed as at yesterday. After submission, the employer stated i was suppose to use a Matrix Formula for the assignment. I have never used the matrix or array formula before this is a problem for me at the moment.
PLEASE i need an assistance, please!!!
Exercise 1
One of our contractors has wrongly saved transactions that need to be cancelled/deleted. He has provided a list of all transactions in tab "Transactions 1".
We have also listet all our transactions in tab "Transactions 2" and marked the ones that need to be cancelled/deleted in the database of our contractor.
Please mark all transactions in tab "Transactions 1" with YES or NO in column G that should be cancelled/deleted according to the list given in "Transactions 2".
Exercise 2
In tab "Transactions 3" please list all transactions from tab "Transactions 2" that need to be cancelled/deleted in rows directly underneath each other.
Important:
For both exercises do not change or sort the lists under tabs "Transaction 1" and "Transaction 2". However, feel free to add additional columns wherever needed.