Originally Posted by

Here is solution:

=IF(INDIRECT("R" & ROW() & "C" & MATCH($F$1,$A$1:$E$1,0),0)="H",A3,"")


Paste this formula in Cells F3 with following conditions:

- F1 should contain date from your data
- F2 empty row
- Column E is blank
- Columns A:D should contain ur data


Hereunder is sample

A B C D E F
01-07-2012 02-07-2012 03-07-2012 03-07-2012

John H H
Gary H
Paul H H Paul

For any detail ping me or visit www.Excelolozy.com