|
|
#1
01-21-2015, 12:47 AM
|
|||
|
|||
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 
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Formatting Duplicates | Joanne | Excel | 6 | 08-05-2013 02:46 AM |
 find and delete duplicates
|
rcVBA | Word VBA | 4 | 05-15-2013 03:08 PM |
|
Deleting Duplicates in Macro
|
jillapass | Excel Programming | 1 | 01-11-2012 10:02 AM |
| Mail duplicates | mixy | Outlook | 0 | 02-10-2011 12:54 AM |
|
sum of duplicates
|
zxmax | Excel | 1 | 09-29-2006 08:29 PM |
Windows 7 64bit 
Office 2007
Linear Mode
