LinkBack URL
About LinkBacks
I just realized why it's not working. On the Salesman sheet, all down Column D are formulas of =A1&" "&B1 to combine the first and last name -- so it appears blank, but really isn't. Is it still possible to do what I'm looking for? Thanks
I just realized why it's not working. On the Salesman sheet, all down Column D are formulas of =A1&" "&B1 to combine the first and last name -- so it appears blank, but really isn't. Is it still possible to do what I'm looking for? Thanks
Try thisDoes that work for you?
=OFFSET(Sheet1!$D$1,0,0,COUNTIF($D$1:$D$500,">"""),1)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
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)
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