Copying data based on repeated values in a column

**ClickingNoise** · 07-04-2013, 11:01 AM

Afternoon All,
In the sample file I've indicated the values I want to see in the Previous Data columns to the right of the sheet.
To expand...when an ID is repeated in Column A, I want to see the corresponding date (Column B) from the previous occurence copied across into Column X - which of course represents the date of the last time it appeared (then Y, Z if it crops up again).
Alternatively, if an ID recurs it's corresponding date might appear on the row for the earlier appearance - my column headers would then refer to the next date & the next and so on.
Any assistance appreciated.

**XOR LX** · 07-04-2013, 11:42 AM

Hi,

In cell R2 of your attachment enter this array formula (confirm with CTRL+SHIFT+ENTER, not just ENTER) and copy across and down:

=IFERROR(IF($B2=MIN(IF($A$2:$A$15=$A2,$B$2:$B$15)),"",IF(SMALL(IF($A$2:$A$15=$A2,$B$2:$B$15),COLUMNS($A$1:A$1))>=$B2,"",SMALL(IF($A$2:$A$15=$A2,$B$2:$B$15),COLUMNS($A$1:A$1)))),"")

Regards