Show duplicate $ amounts in spreadsheet

RobertBradford · Apr 3rd 2016

Hi all, the purpose of this spreadsheet is to check if a store has banked what they have said they would by comparing its banking sheet to the bank statement.

I need a "report" that shows me $ entries that are duplicates in columns C&F.
I also need a "report" that shows me entries in column C that do NOT have a duplicate in column F.

Hoping someone can help.

Regards
Robert

**pike** · Apr 3rd 2016

Re: Show duplicate $ amounts in spreadsheet

Hi RobertBradford
Select all cells in both lists >Go to "Conditional Formatting" > Highlight Cells Rules > "Duplicate Values" > select a format colour >click ok.

RobertBradford · Apr 4th 2016

Re: Show duplicate $ amounts in spreadsheet

Thank you - that's great

**pike** · Apr 4th 2016

Re: Show duplicate $ amounts in spreadsheet

Its not fool proof if you have duplicate values

Code

Option Explicit
Sub Find_Matches()
    Dim CompareRange As Variant, SelectionRange As Variant, xValue As Variant, yValue As Variant


    Set CompareRange = Range("F2:F39")
    Set SelectionRange = Range("C2:C39")
    For Each xValue In SelectionRange
        For Each yValue In CompareRange
            If xValue = yValue Then yValue.Offset(0, 1) = yValue.Offset(0, 1) + 1
        Next yValue
    Next xValue
End Sub

Display More

Show duplicate $ amounts in spreadsheet

Participate now!

Share