| Home > Forum Home > Analyzing Corporate Financial Data > help with blank cells in range > offset and counta | Share |
Offset and counta
Excel Help for Offset And Counta in Analyzing Corporate Financial Data
| Forum Topic | Login |
Offset And Counta | Rate this: (3/5 from 1 vote) |
 | do you mean replace all of the ranges with your suggestion =INDEX(OFFSET($B$2,0,0,COUNTA($B:$B),1),MODE(MATCH(OFFSET($B$2,0,0,COUNTA($B:$B),1),OFFSET($B$2,0,0,COUNTA($B:$B),1),0))) because this gives me an error I would like my formula to work like this to allow me to add more data evry week, but it will not allow the extra cells that are blank. =INDEX(B2:B300,MODE(MATCH(B2:B300,B2:B300,0))) | |
| Posted by tophs1012 on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for offset and counta in the Excel Business Solutions Directory |