Quote:
Originally Posted by xor
Name A1:J1 as d and use the matrix formula:
=IFERROR(INDEX(d,SMALL(IF(d<>"",COLUMN(d)-CELL("col",d)+1),COLUMNS($E:E))),"")
for listing the first non-blank text. Copy the formula to the right to list second, third etc. non-blank text.
If you do not want to use IFERROR, you can instead use:
=IF(COLUMNS($E:E)>SUM(--(d<>"")),"",INDEX(d,SMALL(IF(d<>"",COLUMN(d)-CELL("col",d)+1),COLUMNS($E:E))))
|
Thanks for the reply! However, none of these equations works for me. The first one allows me to enter the formula, but the cell is blank, whereas I would like a formula that when entered in four consecutive cells gives me the first four nonblank text cells within the range I specified.
The second column won't allow me to enter it all due to some sort of error :/