Hi all. I need help in selecting data based on a condition. The condition being that I should not select more than two of the same customer. Below is the input. Please help.
Input:
Name | Amount |
A | 100 |
B | 40 |
C | 50 |
D | 20 |
E | 60 |
F | 80 |
G | 100 |
H | 90 |
A | 85 |
A | 80 |
A | 100 |
D | 40 |
D | 50 |
D | 20 |
H | 60 |
H | 80 |
I | 100 |
M | 90 |
R | 85 |
E | 80 |
C | 87 |
D | 79 |
C | 86 |
P | 50 |
H | 45 |
H | 30 |
E | 20 |
F | 100 |
R | 150 |
E | 66 |
A | 190 |
A | 250 |
A | 300 |
A | 79 |
A | 86 |
F | 50 |
F | 45 |
F | 30 |
G | 20 |
H | 100 |
H | 150 |
A | 65 |
A | 99 |
A | 87 |
In the above example - I can choose A but only twice and the amount can be anything for example - A 65 and A 100 or A 99 and A 87.
Thanks
Solved! Go to Solution.
@SCK @atcodedog05
Thank you all.😁