Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-01-2016, 06:01 AM
gebobs gebobs is offline Alternative to a data validation list? Windows 7 64bit Alternative to a data validation list? Office 2010 64bit
Expert
Alternative to a data validation list?
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default


Yessir! But also, if the list of SKUs is too long, like for the vendor beginning with H, an alternative to data validation that will allow longer lists perhaps.

But yes, the first letter thingee is the priority.
Reply With Quote
  #2  
Old 08-01-2016, 07:13 AM
xor xor is offline Alternative to a data validation list? Windows 10 Alternative to a data validation list? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Is it like shown in Summary!A6?
Attached Files
File Type: xlsx Dummy_3.xlsx (22.7 KB, 10 views)
Reply With Quote
  #3  
Old 08-01-2016, 07:57 AM
gebobs gebobs is offline Alternative to a data validation list? Windows 7 64bit Alternative to a data validation list? Office 2010 64bit
Expert
Alternative to a data validation list?
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Nice. That'll work fine! Thankee, lad.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Alternative to a data validation list? Data Validation - List Webbn111 Excel 9 03-09-2016 04:30 PM
Alternative to a data validation list? Trying to get Data into Validation List according to Client Name and Document Type Maoz Excel 5 01-24-2016 01:17 AM
Alternative to a data validation list? Data Validation List based on Two Named Ranges Rich18144 Excel 4 01-14-2016 04:37 AM
Alternative to a data validation list? Data validation list filter with range defined by OFFSET Mango123 Excel 4 03-18-2014 02:52 PM
Alternative to a data validation list? Conditional data validation (list drop-down) click4akshay Excel 2 04-28-2011 01:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:10 AM.


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