duplicate FINDER

Look at where i have marked READ , manually done through eyes

Need macro to do that by finding duplicate last 6 digit which is 026878 in bothe cases , the long number on the entry after narration

3311 crdb dep indian sweets ref fh834471688026878 on 29/06/23

Macro to plug those read marks

Find attached

For example

Please Login or Register  to view this content.

I think I misread your question, do you want to find all duplicates? If so, place the word "READ" everywhere? That will still be messy

UDF
Use in cell like
H4:
=DupFinder(C5,$C$5:$C$27)
then fildown

Please Login or Register  to view this content.

To differentiate I would not just put READ in each line.

Please Login or Register  to view this content.

According to the attachment a formula VBA demonstration for starters :

PHP Code: 

Sub Demo1()
        Application.ScreenUpdating = False
    With ActiveSheet.UsedRange.Columns(9)
        .Formula = "=IF(LEFT(C1,5)=""BANK "",IFERROR(MID(C2,FIND("" on "",C2)-6,6),""""),"""")"
        .Item(0) = Evaluate(Replace("IF(#>"""",IF(COUNTIF(#,#)>1,""READ"",""""),"""")", "#", .Address))
        .Clear
    End With
        Application.ScreenUpdating = True
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

Thank you all will send feed back from home system here still at work will give feed of which one working for me

JEC read is okay , since you are finding a very rare case , 1 out of 99 situation , but that 1 is money thus important what slip of came in as duplicate