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]
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]