LinkBack URL
About LinkBacks
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
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
Just an idea - duplicates can also be found with Conditional Formatting to some extent. Have you tried that?
Hi, try this
this will return row number of the the first duplicate..
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Thanks All,
Last edited by jhabijay_10; 11-21-2014 at 12:07 PM.
Thanks All,
I did not want duplicate or unique value , I want Position in the list of duplicate value.
By using math function.
Hi, Ref the attachment...
Hi boopathiraja,
Please find the attachment.
Hi boopathiraja,
Please find the attachment.
=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
Say thanks to those who have helped you by clicking Add Reputation star.
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))
Hi, Apply this array formula
Formula:Please Login or Register to view this content.
Hi, Ref the attachment..
Thanks , Its working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks