Best formulas/method for spotting recurring payment(values) from different months

Hi Excel experts!

I am trying to spot recurring payment, pre-arranged by pivot table in columns. For example I list out daily transactions from July to Aug (60 columns) then I would have the vendor names listed in rows.

Now my question is if I want to quickly identify which vendors have recurring(duplicated amount) invoices. what's the best way to go about this?

Currently I would first select the row of a particular vendor then click on conditional formatting and highlight duplicated value. But if I have over 2000 rows(vendors) how can I quickly drag and autofill?? Is there a easier way or better formulas for this?

P.S I won't have a pre-identified value. I am just trying to spot recurring payments throughout different months for different vendors.

Please help....

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Not sure I understand exactly what you want or how you want to do it. I:

1) Select the Pivot tab -> copy sheet.
2) In the copy of the pivot table, I rearrange the fields so that I have:
2a) Vendor number and Invoice amount as the row labels.
2b) Count of Invoice amount as the pivot values field.

Now I can scan the pivot table for invoice amounts that have multiple entries. I don't know how many duplicate entries would constitute a "recurring" payment, but I figure that the recurring payments will have multiple entries.

Will something like that work for you?

I got a count of three for the SM0012001 -- -24438.82 entry in my pivot table. Did you keep the post date as column label? Notice that my description did not include post date anywhere in my pivot table, so it should be counting all of the postings for each invoice value in one entry.

Thanks! Following your comment, I tried rearranging the cells and found below to work much better.

But is there a way to show how many counts for each individual GL account in columns?

I'm not an expert on pivot tables, and your attachment did not attach correctly. It seems like it should be as easy as putting the G/L account number in the column labels field, shouldn't it?

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Since you are new to the forum as a courtesy I have posted it for you this time.

https: //www.mrexcel.com/board/threa...tting.1142586/Administrative Note: