Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-25-2016, 02:03 PM
DB12345 DB12345 is offline Drop down list/ filter help with sharepoint Windows 10 Drop down list/ filter help with sharepoint Office 2013
Novice
Drop down list/ filter help with sharepoint
 
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
Drop down list/ filter help with sharepoint Having a Drop-down list in Word referring to an Excel list celias Word VBA 3 07-11-2016 11:40 PM
Drop down list/ filter help with sharepoint 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:49 PM.


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