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

Za forum.zip (146.8 KB, 12 views)