Thread: Extract duplicates in table
View Single Post
 
Old 01-21-2015, 12:47 AM
goran.c goran.c is offline Windows 7 64bit Office 2007
Novice
  
Join Date: Jan 2015
Posts: 1
goran.c is on a distinguished road
Default Extract duplicates in table
have a problem with the display of duplicate data. In fields D27 and D28 is conditional filtering so if there are duplicates on displays codes in fields D32, D33 .... I have a formula but does not show the exact figures. Where I'm wrong ... FORMULA
=IF(ROWS(E$32:E32)<=$D$27;INDEX('Baza podataka'!C$2:C$3695;SMALL(IF('Baza podataka'!$D$2:$D$3695=$D$25;IF('Baza podataka'!$E$2:$E$3695=$D$26;ROW('Baza podataka'!$E$2:$E$3695)-ROW('Baza podataka'!$E$2)+1));ROWS(E$32:E32)));"")

cell is criteria name $D$25
cell is criteria surname $D$26
Attached Files
File Type: zip Za forum.zip (146.8 KB, 12 views)
Reply With Quote