Help with a formula

[Mariusz]

I have a credit card account that has additional card holder to the main account holder.
The transactions for each of the accounts are pulled into a single sheet.

Here’s the example sheet

How would I get to count the occurrence of the transaction(Walmart) if it shows on the additional card (named Visa Platinum Cashback xxx11040 [MS-TS] in the example) and the main card holder’s account?

So I want the count to show as
Visa Platinum Cashback xxx11040 [MS-TS] : 1
Visa Platinum Cashback xxx21000 [MS]: 0

So basically filter out the duplicate, which it is.
As the transaction was made by the additional card holder and not the main account holder.

Of course the count should be the exact opposite if the purchase wasn’t made by additional card holder.
The solution should take into account that both card could be used at the same store on the same date.

Then the count should be
Visa Platinum Cashback xxx11040 [MS-TS] : 1
Visa Platinum Cashback xxx21000 [MS]: 1

not

Visa Platinum Cashback xxx11040 [MS-TS] : 1
Visa Platinum Cashback xxx21000 [MS]: 2
Again filtering out the duplicate.

[aronos]

When you go to https://sheets.tillerhq.com/ and select your spreadsheet, it shows all of the accounts linked to that sheet. Do these show as two separate accounts there?

[Mariusz]

Think I might be confusing people.
This is more of a general spreadsheet question.
Just need to run some analysis and wonder how to filter out the duplicates

[heather]

I think @aronos is trying to help you determine whether you need both accounts linked to the sheet in order to see the data. Do they flow from the main account holder account and still give you the detail you want? Is there a way to prevent the duplicate from flowing in?

Otherwise, you might experiment with =COUNTIFS for some DIY analysis

COUNTIFS - Google Docs Editors Help

OR the Account filter sheet is handy…

Docs: Account Filter

Overview The Account Filter sheet is useful if you want to review the transactions of any single account linked to your Tiller spreadsheet. This is a read-only sheet for viewing transactions that also already exist in the Transactions sheet. It’s an alternative if you prefer not to filter your Transactions sheet, but want to review transactions for a specific account. How to Install the Account Filter sheet Install or launch the Tiller Community Solutions add-on Open the add-on and choose…

[aronos]

@Mariusz

Think I might be confusing people.
This is more of a general spreadsheet question.
Just need to run some analysis and wonder how to filter out the duplicates

From the look of your example, it seems like you might be loading two accounts with the same data and the easiest solution is to just unlink the duplicate account. I had a similar situation with my 401(k).

[Mariusz]

I probably didn’t do a good job with explaining my scenario.
I have a sheet where I pull all the accounts including additional card holders (they have their own accounts with logins).

Here’s the sample sheet

The transactions marked in red are made by additional card holders.

On the right is table of how I’d like to have the data to be displayed.
Really not sure how to achieve just that.

[heather]

Is all this feeding into the Transactions sheet fed by Tiller Money or this is a manual workflow?

For the latter, I’d recommend brushing up on =countifs

Otherwise, I’d recommend not linking the secondary cards and just have the main login pull the transactions into the Transactions sheet if they also appear there so you don’t get the duplicates.