Hi, I have below Data where I wanted to give conclusion as "Yes" for the Minimum value of column "Min Value" Cluster wise and for remaining it should give as "No". If Min Value is same for whole cluster then it should give "Yes" again. How can I do it.
Record ID | Cluster ID | Min Value | Conclusion |
B | 2532257 | 1 | Yes |
C | 2532257 | 2 | No |
D | 2532257 | 2 | No |
E | 1945503 | 2 | Yes |
F | 1945503 | 6 | No |
G | 1945503 | 7 | No |
H | 1846521 | 1 | Yes |
I | 1846521 | 2 | No |
A | 1846521 | 3 | No |
K | 1846521 | 5 | No |
L | 1846521 | 5 | No |
M | 1846521 | 5 | No |
N | 1846521 | 5 | No |
O | 1645601 | 1 | Yes |
P | 1645601 | 1 | Yes |
Q | 1645601 | 1 | Yes |
R | 1645601 | 4 | No |
S | 1542378 | 1 | Yes |
T | 1542378 | 1 | Yes |
U | 654379 | 4 | Yes |
V | 654379 | 4 | Yes |
Solved! Go to Solution.
@Ayaanarjun-5885 One wya of doing this