Hello,
I hope someone can help me:
I have a problem with deleting rows
I have a column with data, witch also contains empty cells, I want all the empty cells filtered out. Filtering is not an option!
I use the following matrix formule:
{=ALS(RIJ()>SOM(--(A2:$A$500<>""));"";INDEX(A2:$A$500;KLEINSTE(ALS(A2:$A$500<>"";RIJ(A2:$A$500));RIJ(A2:$A$500))))}
I think it's this converted to English?:
{=IF(ROW()>SUM(--(A3:$A$500<>""));"";INDEX(A3:$A$500;SMALLEST(ALS(A3:$A$500<>"";ROW(A3:$A$500));ROW(A3:$A$500))))}
But it doesn't work for me.
Does someone have a solution?
Thanks
Bookmarks