View Single Post
 
Old 01-27-2015, 11:24 AM
pemaolca pemaolca is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Jan 2015
Posts: 2
pemaolca is on a distinguished road
Thumbs up

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.
Reply With Quote