SeanMcBride
New Member
- Joined
- Oct 28, 2017
- Messages
- 2
Here's the scenario:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]195[/TD]
[TD]Skeleton[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]195[/TD]
[TD]Skeleton[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]32787[/TD]
[TD]Costume[/TD]
[TD]Fales[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]5695[/TD]
[TD]Costume[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]698974[/TD]
[TD]Costume[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]30073[/TD]
[TD]Witch[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]2757[/TD]
[TD]Witch[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]999999[/TD]
[TD]Witch[/TD]
[TD]False[/TD]
[/TR]
</tbody>[/TABLE]
In a worksheet with over 10,000 lines, I'm trying to create a formula or macro to select the higher value in column B where duplicates exist in Column A. For example, Column A has three duplicates of 17. I would want the formula to denote which value of those duplicates n Column B is the lesser of all the duplicates by some indicator. In other words, if duplicates in Column A exist, select the lesser corresponding value of that series in Column B. Help!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]195[/TD]
[TD]Skeleton[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]195[/TD]
[TD]Skeleton[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]32787[/TD]
[TD]Costume[/TD]
[TD]Fales[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]5695[/TD]
[TD]Costume[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]698974[/TD]
[TD]Costume[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]30073[/TD]
[TD]Witch[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]2757[/TD]
[TD]Witch[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]999999[/TD]
[TD]Witch[/TD]
[TD]False[/TD]
[/TR]
</tbody>[/TABLE]
In a worksheet with over 10,000 lines, I'm trying to create a formula or macro to select the higher value in column B where duplicates exist in Column A. For example, Column A has three duplicates of 17. I would want the formula to denote which value of those duplicates n Column B is the lesser of all the duplicates by some indicator. In other words, if duplicates in Column A exist, select the lesser corresponding value of that series in Column B. Help!