-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
non-blank cell value
-
C
How to make dynamic charts at Excel by using non-blank values?
Dear all. Now I met a problem. I want to make dynamic pie charts at EXCEL by using non-blank values. I have followed one of the popular videos which teaches how to do this step by step. However, when I use this function it does not work. The formula that I used is ...- comeacross
- Thread
- dynamic charts excel non-blank cell value
- Replies: 2
- Forum: Excel Questions
-
S
Return non blank list
Hi, does any1 know how to return all non-blank items from a row (cafe table2) to another row on another sheet (2) i have worked very hard so far but not been able to do it. so far i have =IFERROR(INDEX('Cafe Table'!B2:BQ2,SMALL(IF(LEN('Cafe Table'!B2:BQ2)>0,COLUMN('Cafe...- subatomic
- Thread
- non-blank cell value
- Replies: 3
- Forum: Excel Questions
-
R
Pull the first non blank cell data
Hi,I am using an array formula to pull up the first non-blank cell data using this formula =INDEX('Raw Data'!MB2:MB1048576,MATCH(FALSE,ISBLANK(MB2:MB1048576),0)), however I need this to be add onto merged cells and its not working, Excel 2010 does not allow array formulas in a merged cell, I...- Rajasree
- Thread
- array formulas non-blank cell value wildcard
- Replies: 1
- Forum: Excel Questions
