Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Misc

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-25-2016, 02:03 PM
DB12345 DB12345 is offline Windows 10 Office 2013
Novice
 
Join Date: Oct 2016
Posts: 1
DB12345 is on a distinguished road
Default Drop down list/ filter help with sharepoint

I am attempting to filter data from a share point library List and I am having a few issues.
The List I am using is a receiving log that has multiple duplicate Part because it has been added to constantly for years. When I click the drop down list it displays all the part numbers ( including duplicates) so when I click on a random Part number it will filter the Lot number, BUT it will not give me the most recent lot number, which is what I need. It will give me the lot number associated to that part according to the Sharepoint library. I want to know if there is a work around or solution for my issue. here is an example of my problem.

Part Number: DIwater1 Lot number: DIW123


DIwater1 DIW124
DIwater1 DIW125

I have to click on the bottom part number to get the most recent lot number but I would like it to automatically choose the most recent lot number, is there anyway to do this?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Having a Drop-down list in Word referring to an Excel list celias Word VBA 3 07-11-2016 11:40 PM
Filter Mail Merge based on a list of filter criteria AusSteelMan Mail Merge 2 05-09-2016 03:35 PM
Excel Template to Sharepoint List sforney123 Excel 0 11-07-2011 08:10 AM
Multiple sharepoint list pst file vik__ Outlook 0 10-30-2010 02:04 AM
drop down menu that control filter on other column massi Excel 0 08-24-2010 01:13 PM


All times are GMT -7. The time now is 10:39 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft