Thanks gebobs, that's a great and simple ideia... but if I can, I want a table that doesn't need Human interaction. For that I have the table in Sheet 2
"If(ROWS($G$6:G6)<COUNTA($B$6:$B$21);"";INDEX($B$6 :$B$21:AGGREGATE(15;6;(ROW($B$6:$B$21)-ROW(($B$6)+1<>"");ROW($G$6:G6)))))"
I think that the formula is the right one (I can't see the mistake inside the Formula)... But it doesn't display the information, don't know if the problem is that the cells on B6 to B21 have another Formula and no value.
|