I have three columns. Only one cell in column A will have a value, which will be "Active". Column B is locations. In column C I'm trying to get anything that at or below the "Active" indicator to populate as "Down" and anything above the "Active" marker to populate as "Up".
<tbody>
</tbody>
Minn | Up | |
Lars | Up | |
Active | X5 | Down |
Lars_1 | Down | |
Y2 | Down | |
Z6 | Down |
<tbody>
</tbody>