Question: From the attached file, I need the functions for the below: Find and highlight columns that contain the same IMO and the Date +/- 2

From the attached file, I need the functions for the below:

  1. Find and highlight columns that contain the same IMO and the Date +/- 2 days , Result OK
  2. Find and highlight columns contain the same IMO and the Date +/- 2 days, if different NRT Result wrong NRT
  3. Find and highlight columns contain with the same IMO and the Date +/- 2 days, if different AGENT Result wrong AGENTS
  4. ANSWER SHOULD BE IN THE SAME Excel sheet along with Formula
Vessel Name IMO NRT Date Agent
AUSTRALIA 1010959 263 September 2, 2021 SHARAFS
Adel II 7304912 873 September 04, 2020 DHOFAR
Adel II 7304912 873 September 27, 2020 DHOFAR
Trust 1 7504158 1165 September 05, 2021 DHOFAR
TRUST 1 7504158 1523 September 6, 2021 DHOFAR
Bluefort 7816874 6074 September 08, 2021 SHARAF
BLUEFORT 7816874 6074 September 8, 2021 SHARAFS
Raysut 1 7821879 2025 September 16, 2020 TOWELL
Capt.Osama 7900596 4326 September 16, 2020 DHOFAR
MV Siham 1 8129474 1410 September 19, 2020 GULF
Hajeh Amira 8204119 2064 September 12, 2021 SALALAH2
HAJEH AMIRA 8204119 2064 September 16, 2021 SALALAH
AK Hamburg 8204157 3425 September 05, 2021 DHOFAR
AK HAMBURG 8204157 3425 September 18, 2021 DHOFAR
AK Hamburg 8204157 3425 September 18, 2021 DHOFAR
AK Hamburg 8204157 3425 September 28, 2021 DHOFAR
AK HAMBURG 8204157 3425 September 9, 2021 DHOFAR
Emad-Y 8204676 1754 September 17, 2020 SALALAH2
Sarah-F 8321668 3652 September 17, 2020 DHOFAR
MSC Chiara 8420892 13075 September 27, 2020 MSC
VIKING 8509088 72 September 16, 2021 KHIMJI
African A 8512619 2998 September 07, 2020 DHOFAR
Captain Hamada 8602361 3320 September 22, 2020 DHOFAR
Gmt Astro 8606056 14919 September 02, 2021 KANOO
Gmt Astro 8606056 14919 September 10, 2020 KANOO
GMT ASTRO 8606056 14919 September 2, 2021 KANOO
Nacc Milburn 8606197 1920 September 05, 2021 TOWELL
Nacc Milburn 8606197 1920 September 11, 2020 TOWELL
Nacc Milburn 8606197 1920 September 16, 2021 TOWELL
NACC MILBURN 8606197 1920 September 18, 2021 TOWELL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Would you please help me with the project? Details are attached. I really have no idea how to start? ACCT4112 Project: Accounting Data Analyses Students as Business Advisors: Preparing financial...

Q:

Find attached Ingredients: Water, MCC, Salt, Nicotine, pH regulator, sweeteners and flavours I am wondering why the decision to go with LYFT. I understand migrating to LYFT would be easier from sells...

Q:

could you please help me Accountung Theory and practice course assignment? i have to do next week monday. Please i need your help i have to choose 3 articles below and apply acoounting theory. I...

Q:

Hello, Sarah could you please help me Accountung Theory and practice course assignment? i have to do next week monday. Please i need your help i have to choose 3 articles below and apply acoounting...

Q:

Hello, Sarah could you please help me Accountung Theory and practice course assignment? i have to do next week monday. Please i need your help i have to choose 3 articles below and apply acoounting...

Q:

Hi, please Ihave this project to do as soon as possible. Could you help me? Thank you! Instructions to ACCT4112 Project: Accounting Data Analyses 1. From the \"Project\" section of the Content...

Q:

Hello, Could you please help me with the excel assignment. I have to submit it by tomorrow night. You have to click on enable editing and then click Start for the numbers to show. Thank you....

Q:

Can someone help me correct these two things for my project? (1) Residential Service Revenue: Revenue is recognized on a monthly basis ($18 per month). Therefore if the contract starts from 2/1/2015,...

Q:

Can someone help me correct these two things for my project? (1) Residential Service Revenue: Revenue is recognized on a monthly basis ($18 per month). Therefore if the contract starts from 2/1/2015,...

Q:

please help me answer question by excel 1. Each team member will pick a company to analyze. That way, teams with 5 members will be working with portfolios of 5 different stocks, and teams with 4...

Q:

One kilogram of air is compressed in a cylinder for each of the quasi-equilibrium processes listed in the following table. Fill in the missing quantities for the selected process. Process P. (kPa)...

Q:

MacAskill Corp. has the following portfolio of securities acquired for trading purposes and accounted for using the fair value through net income model at September 30, 2014, the end of the company~...

Q:

civilization improved or declined in the period in the twentieth century?

Q:

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...