|
|
#3
01-27-2015, 11:24 AM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Adding sums from simuliar tables from different sheets. | LameDuck | Excel | 0 | 12-04-2014 08:57 PM |
 Excel sheets
|
ubns | Excel | 4 | 04-15-2012 10:48 PM |
| Copying sheets | DavidSNPCPA | Excel | 2 | 01-19-2012 03:54 AM |
| Linking sheets to fetch transactions from sheets to another | waqer | Excel | 4 | 09-01-2011 12:35 PM |
| Linking Excel Pivot Tables in a Word Document | wmarsh3561 | Word Tables | 0 | 11-17-2009 06:29 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode