Hi all

I am 120% new to this forum and any help is much appreciated!!

I have the following Array Formula:

=IF($A4=1,IFERROR(INDEX(B$3:B$20,SMALL(IF($A$3:$A$20=0,ROW($A$3:$A$20)-ROW($A$3)+1),COUNTIF($A$3:A3,$A$3))),""),"")

When I paste the formula ein Excel 2010 and confirm the entry with Ctrl+Shift+Enter I get the message that the formula is wrong but I am pretty sure that this is right. Also, Excel does not add the "{" braces.

Any idea? Any feedback would be appreciated!! The formula is supposed to be in G4 and H4 and the copied down.

ZMY_Files_SIT_SOURCE.xlsx

The result should look like this...

Attachment 224495

Thanks to every one!!

Georg