Document Control - Duplicate Values and Corresponding Columns

SuperCoog

New Member
Joined
Sep 26, 2017
Messages
11
Hello,

I am building a spreadsheet to keep track of construction drawings. For those that do not know, these drawings will get revised from time to time, so it is important to know which revision is the most up to date.

So far what I have is a column (Column A) which has a list of drawing names, and a column (Column B) which has the corresponding revision.
[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Drawing 1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Drawing 2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Drawing 3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Drawing 4
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]Drawing 5
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]Drawing 1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]Drawing 1
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]Drawing 2
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]Drawing 3
[/TD]
[TD]1
[/TD]
[/TR]
</tbody>[/TABLE]

As shown with the table above, Rows 1, 6, and 7 (also 2 and 8, 3 and 9) are duplicate values that have various corresponding values in the adjacent column.

What I am aiming to do is write some sort of statement that will be able to look in Column A, determine if there are duplicate values, then look in column B and determine which value is the largest. The result just needs to be a True of False statement, as in, it is true that this row reflects the latest revision

[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Drawing 1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Drawing 2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Drawing 3
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Drawing 4
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]Drawing 5
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]Drawing 1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]Drawing 1
[/TD]
[TD]2
[/TD]
[TD]True
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]Drawing 2
[/TD]
[TD]1
[/TD]
[TD]True
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]Drawing 3
[/TD]
[TD]1
[/TD]
[TD]True
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

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