I am looking for a formula (maybe filter) which reduces a list as users select item. Thinking it may be a combination of filter and unique formula.
List 1 is the master list of all the names.
B3:B5 is the selection area. As users select names, the selection list should reduce. So since Frank and Billing have already been selected, only Ronald and Karen should be available in B5 drop down list.
Thanks so much!
In 365, this is a little easier than in other versions.
=COUNTIF(B:B,G3)
in col H, and this in col I:
=IFERROR(INDEX(G:G,AGGREGATE(15,6,ROW([List 1])/([List 2]=0),ROWS(I$3:I3))),"")
Refer to col I as the DV range.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
You'll need to create another list to use as the data validation list. Put this formula in I3:
Then highlight B3:B5 and change the data validation to be a list contained in:
Please Login or Register to view this content.
Note the # at the end - it's important.Please Login or Register to view this content.
That should then reduce the available list when you select users into other slots.
WBD
Office 365 on Windows 11, looking for ✶ rep!
Both solutions worked perfectly....thanks WideBoy and Glenn!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks