Originally Posted by
Richard Buttrey
You're asking us to guess what you mean by 'the same invoice series' and how it should be treated.
If I understand your request, the most common approach, or at least the one I seem to use most often in cases like this, is to use a helper column which contains the vendor number and invoice number concatenated together. Then you can use a COUNTIF() on the helper column to see how many occurrences of each cell in the helper column, there is in the whole of the helper column. Filter the COUNTIF() column for values >1.
HTH
Bookmarks