report same rows between 2 sheets.

Hello to all

I believe that these formulas will work using the 2007 version.
1. Populate cell A1 using: =COUNTIF(articoli!A6:A926,A2)
Note that for aesthetic purposes the value in A1 could hidden by choosing the white font.
2. Populate A5 and down using: =IF(ROWS(A$1:A1)>A$1,"",A$2)
3. Populate B5 and down using the following array entered formula**: =IF($A5="","",INDEX(articoli!B$6:B$926,SMALL(IF(articoli!$A$6:$A$926=$A5,ROW($A$6:$A$926)-ROW($A$5)),ROWS($A$1:$A1))))
4. Once the formula in cell B5 is copied down then drag the fill handle over to column L.
5. [Optional] As the array entered formula will display a zero in cells that reference blank cells on the articoli sheet, conditional formatting may be applied to hide them (modeled in file).
Note that in the attached file the formulas and conditional formatting are only copied down to row 30.
**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).
Let us know if you have any questions.

Modify the formula in cell B5 so that it reads:

Formula:

Please Login or Register  to view this content.

Remember, after making the change highlighted in red, to press the Ctrl, Shift and Enter keys to activate the formula before copying over and down.
Let us know if you have any questions.