LinkBack URL
About LinkBacks
Hello all
I need to make Cascade drop down for Cell B2 in attendance sheet that match with column C in Waiting list in my attached file
Hello all
I need to make Cascade drop down for Cell B2 in attendance sheet that match with column C in Waiting list in my attached file
There is no any GERY in Name
sorry its mistake in writeingOriginally Posted by tim201110
GREY is the correct
https://search.yahoo.com/search;_ylt...r=yfp-t-s&fp=1
or as in the file
In attendance sheet in "B2"Formula:
Please Login or Register to view this content.
In this formula match with two criteria due to duplicate name in waiting sheet but batch number unique.
Hence i add batch size in criteria & mentioned size in waiting list sheet.
Refer attach file.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
i found link for how can make it but the problem the data must be sorted because its give error
the link as the follow
http://www.contextures.com/xlDataVal13.html
can some expert change this to fit my needs
See attached:
Named range Batch:
Refers to:
=OFFSET('Waiting list'!$G$2,,,COUNT('Waiting list'!$G$2:$G$100),1)
on "Waiting list"
in G2
=IFERROR(INDEX($C$2:$C$100,SMALL(IF($A$2:$A$100=Attendance!$B$1,ROW($C$2:$C$100)-ROW($C$2)+1,""),ROWS($C$2:C2))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Copy down
in "Attendance"
B2
Data Validation
=list
Source: =Batch
really good man for all work you shared
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks