SeanMcBride
New Member
- Joined
- Oct 28, 2017
- Messages
- 2
Here's the scenario:
<tbody>
</tbody>
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!
Column A | Column B | Column C | Column D |
14 | 195 | Skeleton | |
14 | 195 | Skeleton | |
17 | 32787 | Costume | Fales |
17 | 5695 | Costume | True |
17 | 698974 | Costume | False |
23 | 30073 | Witch | False |
23 | 2757 | Witch | True |
23 | 999999 | Witch | False |
<tbody>
</tbody>
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!