Snasui Excel Forum

Hi dear
I need your help how to populate data in Sheet WHT-HO from sheet Pur-HO column O placing them in highlight cells of sheet WHT-HO.

I also attached a
Thanks

here is the attached

Cell A4 on sheet 'Pur-HO' enter this formula:

=IFERROR(INDEX('Pur-HO'!A:A,AGGREGATE(15,6,ROW('Pur-HO'!$A$5:$A$55)/('Pur-HO'!$O$5:$O$55="WHT"),ROWS($A$4:A4))),"")

Enter and copy down. Apply to other column by changing the highlighted character above.

thank you