Hi,
I have raw data in Sheet1. The criteria is "Yard Name". I need to extract the respective rows for each yard in a different sheet as shown here below. I would like to apply array formula. I use Exel 2003. Please for your help.:confused:
<TABLE style="WIDTH: 838pt; BORDER-COLLAPSE...