Audit of data in an excel sheet.

CliffyBiro

New Member
Joined
Jan 19, 2015
Messages
7
Hi There,
Hope this is in the right place.
Im trying to make an audit of data quick and easy to do in excel.
I have a list of reference numbers in a column, the reference number could be in the column twice or three times.
Depending on whether its in twice or three times I then want to check the names against the reference numbers match the assigned name in two other columns!
For the example below, for Ref 531, I want to check Jerry is Assigned Eng 1 and Dusty is Assigned Eng 2.
Ref 532 I need to check if Jerry is assigned eng 1 and then if Rob or Kevin are Assigned Eng 2.
If the responsible engineer is not the same as the assigned engineers I need to highlight it as ref 533, Jerry and Dusty DON'T appear in Assigned Eng 1 or 2.

Ref
Responsible Engineer
Assgined Engineer 1
Assinged Engineer 2
531
Jerry
Jerry
Dusty
531
Dusty
Jerry
Dusty
532
Jerry
Jerry
Kevin
532
Rob
Jerry
Kevin
532
Kevin
Jerry
Kevin
533
Jerry
Ray
Rob
533
Dusty
Ray
Rob

<tbody>
</tbody>
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,223,228
Messages
6,170,875
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top