HI

I HAVE A FORMULA THAT TAKES THE ENTRIES FROM A SPECIFIED ROW IN ONE WORKSHEET AND FILTERS OUT THE DUPLICATES IN ANOTHER WORKSHEET, BUT THE WAY I HAVE THE FORMULA IT TAKES EVERY ENRY FROM EVERY COLUMN IN THE SPECIFIED ROW. WHAT I NEED IF FOR THE FORMULA TO RETURN EVERY SECOND COLUMN ENTRY IN THE SPECIFIED ROW. I HAVE TRIED USING OFFSET, BUT HAVING NOT USED OFFSET MUCH BEFORE I'M NOT HAVING ANY LUCK.

=IFERROR(IFERROR(IFERROR(IFERROR(INDEX('Data Entry'!$D$3:$AZ$3, MATCH(0, COUNTIF($A$2:$A2,'Data Entry'!$D$3:$AZ$3), 0)), INDEX('Data Entry'!$D$3:$CZ$3, MATCH(0, COUNTIF($A$2:$A2,'Data Entry'!$D$3:$CZ$3), 0))), INDEX('Data Entry'!$D$3:$EZ$3, MATCH(0, COUNTIF($A$2:$A2,'Data Entry'!$D$3:$EZ$3), 0))),INDEX('Data Entry'!$D$3:$GZ$3, MATCH(0, COUNTIF($A$2:$A2,'Data Entry'!$D$3:$GZ$3), 0))), "")