Jiinglelocks
New Member
- Joined
- Jun 7, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hello, I'm not sure if I'm asking my question correctly but hopefully I can make it clear. This is an example of my data:
I have animal names, a distance in meters and a "closest" column, in which I need to display a "Y" next to the minimum distance of that group (so the minimum distance of the Adder distances, the minimum distance of the American Mink distances and so on...).
I have this formula working which applies to a cell range that I pre-define, this is for Adders:
But I need the range to be dynamic. Ideally excel or VBA would figure out that "Adder" is contained in the range A2:A12 and find the minimum value in the same range of the adjacent column. I have hundreds of animal names to go through so I can't really add the names individually. Is what I'm asking possible?
Thank you for your time!
I have animal names, a distance in meters and a "closest" column, in which I need to display a "Y" next to the minimum distance of that group (so the minimum distance of the Adder distances, the minimum distance of the American Mink distances and so on...).
I have this formula working which applies to a cell range that I pre-define, this is for Adders:
But I need the range to be dynamic. Ideally excel or VBA would figure out that "Adder" is contained in the range A2:A12 and find the minimum value in the same range of the adjacent column. I have hundreds of animal names to go through so I can't really add the names individually. Is what I'm asking possible?
Thank you for your time!