• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

display all rows with blank cells and the last row with a non blank cell

J

joharmenezes

Member
Suppose I have cells a1 to a50000, some of which have values while others are blank. Let's suppose only cells a1234 and a3245 are blank. So I would like to create a filter which displays cells a1234, a3245 and also cells a1233, a3244. is that possible?
 
Hi,


It is possible to select the blank cells in Excel 2007 as well as with some data. And you cannot filter by rows it can be done only by cell value.


Thanks,

Suresh Kumar S
 
Hi Suresh Kumar, if my blank cell is on the nth row. how do I create a filter such that it only displays the nth and (n-1)th row?
 
Hi ,


If you can use a helper column , use the following formula in the helper column :


=IF(ISBLANK(A1),1,IF(ISBLANK(A2),1,0))


Include this column in your Autofilter , and filter this column on 1.


Narayan
 
Hi NARAYANK991 your formula makes sense but for some reason I have to double click the cells in the A column for the formula to work as it doesnt display 1 but only 0s unless double clicked
 
Hi ,


I am not able to understand what the problem is ; can you try with this formula ?


=IF(A1="",1,IF(A2="",1,0))


Narayan
 
You must log in or register to reply here.
Back
Top