Hi, I am wondering if someone could help me out with the following:
I want the Count and Multiple column to not occur multiple times if the Account holder name occurs more than once. This is how my data looks right now:
Account holder name | Count | Multiple |
A Corp | 1 | FALSE |
A. Corp | 1 | FALSE |
AAB Wurmböck GmbH | 1 | FALSE |
Abele, Gustav | 1 | FALSE |
Account Holder 1234567 | 2 | TRUE |
Account Holder 1234567 | 2 | TRUE |
Ahrend | 2 | TRUE |
Ahrend | 2 | TRUE |
This is how I need it to be, with empty cells if the Account holder name is the same as the row above.
Account holder name | Count | Multiple |
A Corp | 1 | FALSE |
A. Corp | 1 | FALSE |
AAB Wurmböck GmbH | 1 | FALSE |
Abele, Gustav | 1 | FALSE |
Account Holder 1234567 | 2 | TRUE |
Account Holder 1234567 | ||
Ahrend | 2 | TRUE |
Ahrend |
Hope someone can help me with this problem?
Solved! Go to Solution.
It did! Thanks a lot :)
Happy to help : ) @JudithZonder
Cheers and have a nice day!