Position of duplicate Value in the list

[jhabijay_10]

Hi,
Can any one help me in finding the exact position, if there is duplicate value in the list.

For Ex:- 45 Result:Position (=match(45,List,0)---if Drag Down)
35 1
25 2
25 3
10 4
5

[bmouse]

Just an idea - duplicates can also be found with Conditional Formatting to some extent. Have you tried that?

[boopathiraja]

Hi, try this
this will return row number of the the first duplicate..

Please Login or Register  to view this content.

[jhabijay_10]

Thanks All,

[jhabijay_10]

Thanks All,
I did not want duplicate or unique value , I want Position in the list of duplicate value.
By using math function.

[boopathiraja]

Hi, Ref the attachment...

[jhabijay_10]

Hi boopathiraja,

Please find the attachment.

[jhabijay_10]

Hi boopathiraja,

Please find the attachment.

[samba_ravi]

=SMALL(IF($D$6:$D$15=$I8,ROW(INDIRECT("1:"&ROWS($D$6:$D$15)))),COUNTIF($I$8:$I8,$I8))
Try this array formula in H8 and copy towards down
Shift+Ctrl+Enter

[samba_ravi]

another one (Non array formula)
H8=SMALL(INDEX(($D$6:$D$15=$I8)*ROW(INDIRECT("1:"&ROWS($D$6:$D$15)))+($D$6:$D$15<>$I8)*10^10,0),COUNTIF($I$8:$I8,$I8))

[boopathiraja]

Hi, Apply this array formula

Please Login or Register  to view this content.

[boopathiraja]

Hi, Ref the attachment..

[jhabijay_10]

Thanks , Its working