LinkBack URL
About LinkBacks
Works perfect! Thanks!Originally Posted by ChemistB
Try thisDoes that work for you?
=OFFSET(Sheet1!$D$1,0,0,COUNTIF($D$1:$D$500,">"""),1)
Works perfect! Thanks!Try thisDoes that work for you?=OFFSET(Sheet1!$D$1,0,0,COUNTIF($D$1:$D$500,">"""),1)
It looks like your issue was resolved, so I hope you don't mind if I hyjack your thread since my issue is similar to yours.
I am using the equation mentioned, and I also have a long list of "blank" cells (they actually have equations in them that will fill in the cell when applicable). My new dropdown validation list recognizes the 2 cells that are not blank, however it shows 2 blank spots, instead of two actual items from my list. Did I make a mistake somewhere?
Last edited by sabbott13; 12-20-2009 at 02:27 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks