Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 03-28-2018, 12:15 AM
IBRA2018 IBRA2018 is offline How to create an Auto list with No Blank Cell -- HELP Windows 8 How to create an Auto list with No Blank Cell -- HELP Office 2016
Novice
How to create an Auto list with No Blank Cell -- HELP
 
Join Date: Mar 2018
Posts: 17
IBRA2018 is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
Here you go!

Thanks

I just have one problem...

in the 3 named values, p.e. CntInProg, CntPending, CntCompleted which you gave me I have added one value for Not Assigned which is CntNot Assigned when I did both with space CntNot Assigned and without space
CntNotAssigned I get error in the result

#Name?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Drop Down list to change cell color bksmith Excel 2 08-21-2017 02:37 AM
Have a cell filled black when blank in dropdown list Aussie_81 Excel 14 04-06-2017 04:50 AM
How to create an Auto list with No Blank Cell -- HELP Formulato say if cell is blank do this, if not blank do this. mbesspiata Excel 1 01-17-2015 05:02 AM
Auto add a list cell if the last list cell is filled tasuooooo Excel 1 07-31-2012 08:40 PM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft