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.😁
