Drop Down List Ignore Blank
..Hi,
I am trying to use a drop down list and have checked the "ignore blank" option but it does not ignore the blank cells. So I did the following to try and cricumvent it but need some help. Column M contains the list Column N I put an if statment to set the cell's to 1 if they are not blank Column O I used the index to list only the cell's that have something in it. Column P I did an iserror & vlookup to create a list of only "non-blank" cells N4 I used the Countif statement to see how many rows have info. Curretnly n4=48 I would like to use that number to set the end of the list I am trying to do the following: List = p$6:p$(6+n4)----would like it to read p$6:p$54 Thanks, Ben |
Drop Down List Ignore Blank
Try:
=OFFSET($P$6,0,0,N4,1) "Ben Dummar" wrote: .Hi, I am trying to use a drop down list and have checked the "ignore blank" option but it does not ignore the blank cells. So I did the following to try and cricumvent it but need some help. Column M contains the list Column N I put an if statment to set the cell's to 1 if they are not blank Column O I used the index to list only the cell's that have something in it. Column P I did an iserror & vlookup to create a list of only "non-blank" cells N4 I used the Countif statement to see how many rows have info. Curretnly n4=48 I would like to use that number to set the end of the list I am trying to do the following: List = p$6:p$(6+n4)----would like it to read p$6:p$54 Thanks, Ben |
All times are GMT +1. The time now is 10:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com