Friends,
I have an excel sheet contains details of Student Grade(Grade1 etc. up to Grade 10), Student Name(100 students) in colums A and B.
I want to get the list of students when I insert the grade (i.e Grade3).
This is to be included in a seperate sheet. Grade will be selected data validation list. Name list to be appeared in a single column.
Please help!
Rasika
Last edited by RASIKA_99; 03-27-2020 at 12:02 PM.
Try:
Formula:
Please Login or Register to view this content.
Press CTRL+SHIFT+ENTER to make it an array
Last edited by RChad; 03-27-2020 at 09:46 AM.
This works fine. Thanks RChad.
As you are using the 2016 version of Excel you could also try this non-array* option:Formula:Please Login or Register to view this content.
*Activate by pressing the Enter key.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks