| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Eliminating blank cells in a list on a ROW
I need help converting Pearson's array formula from a list in a column to a list in a row: http://www.cpearson.com/excel/noblanks.htm =IF(ROW()-ROW(NoBlanksRange)+1ROWS(BlanksRange)- COUNTBLANK(BlanksRange),"",INDIRECT(ADDRESS(SMALL( (IF(BlanksRange<"",ROW(BlanksRange),ROW()+ROWS(Bl anksRange))), ROW()-ROW(NoBlanksRange)+1),COLUMN(BlanksRange),4))) Thanks in advance! -- grime ------------------------------------------------------------------------ grime's Profile: http://www.excelforum.com/member.php...o&userid=19227 View this thread: http://www.excelforum.com/showthread...hreadid=481884 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbered List with Blank Spaces, etc. | Excel Discussion (Misc queries) | |||
| Blank cells represented in area charts | Charts and Charting in Excel | |||
| removing blank cells from a column | Excel Discussion (Misc queries) | |||
| Ignore Blanks in Data Validation | Excel Worksheet Functions | |||
| How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
Threaded Mode
