Offset row data

[blackorchids2002]

Hi Everyone,

Is it possible to use offset formula to move to the next row data? I am trying to achieve all H&S data will be captured in sheet 2. I know there is an easy way to do that by filtering it. But I am trying to automate the summary template in sheet by putting a formula from the data in sheet 1 below.

Code	Customer Unit Price
Err	0
Err	0
Err	0
Err	0
Err	0
H&S	68
Err	0
Err	0
Err	0
Err	0
Err	0
Err	0
Err	0
Err	0
Err	0
Err	0
H&S	69
H&S	70
H&S	71
Err	0
Err	0

<colgroup><col><col></colgroup><tbody>
</tbody>

Thanks.

 

[Aladin Akyurek]

Hi Everyone,

Is it possible to use offset formula to move to the next row data? I am trying to achieve all H&S data will be captured in sheet 2. I know there is an easy way to do that by filtering it. But I am trying to automate the summary template in sheet by putting a formula from the data in sheet 1 below.

Code	Customer Unit Price
Err
Err
Err
Err
Err
H&S	68
Err
Err
Err
Err
Err
Err
Err
Err
Err
Err
H&S	69
H&S	70
H&S	71
Err
Err

<tbody>
</tbody>

Thanks.

Try to adapt the set up of Post#3 in:

http://www.mrexcel.com/forum/excel-questions/307832-multiple-vlookups.html#post1511354

to your data.