Return all values in a column

[chriswrcg]

This should be a simple array index match formula but I can not make it work. I have no Idea what I am doing wrong. It is supposed to return each unique date for the individual but it just returns the same date again and again.

[Bo_Ry]

Please try at H2

=IFERROR(AGGREGATE(15,6,$B$2:$B$8780/($A$2:$A$8780=$G2)/($B$2:$B$8780>MAX($G2:G2)),1),"")

[samba_ravi]

try below array formula in h2, copy and paste across
=IFERROR(INDEX($B$2:$B$36, MATCH(0, IF($G2=$A$2:$A$36, COUNTIF($G2:G2,$B$2:$B$36), ""), 0)),"")

Please Login or Register  to view this content.

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

[Czeslaw]

Power Query

Please Login or Register  to view this content.

[chriswrcg]

Thank you as always.