Return empty cell if value from another column is same as row above

[JudithZonder]

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?

[atcodedog05 · Accepted solution]

Hi @JudithZonder 

Here is how you can do it.

Workflow:

Hope this helps : )

[JudithZonder]

It did! Thanks a lot :)

[atcodedog05]

Happy to help : ) @JudithZonder 

Cheers and have a nice day!