Make list only passed students from all names

[kamaruddinjnv]

I have 40 students name.
I need pick name only passed students in a column rankwise without any gap of row.

 

[mumps]

Can you post a sample of what your data looks like? Look at section B at this link for instructions on how to post data.
https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

 

[kamaruddinjnv]

Example
A B
1. X. 80
2. Y. 70
3. Z. 60
4. P. 32
5. H. 20
6. J. 45
7. N. 90

Make a list in c column only greater than 33% students rankwise without any row gap.

 

[mumps]

Start by putting headers in row 1 of your sheet so that you data starts in row 2 and then run this macro:

Sub Test()
    Application.ScreenUpdating = False
    Dim LastRow As Long
    LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
    Range("A1:B" & LastRow).AutoFilter Field:=2, Criteria1:=">33"
    Range("A2:A" & LastRow).SpecialCells(xlCellTypeVisible).Copy Cells(2, 3)
    If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False
    Application.ScreenUpdating = True
End Sub

 

[AhoyNC]

Here is a formula way if you are interested.
I wasn't sure when you said grades above 33% if you are doing a ranking on the grades or just grades above 33 in your column B.

This is an array formula and must be entered with CTRL-SHIFT-ENTER.
Then drag formula down column as needed.

Excel Workbook
	A	B	C	D	E
1	Name	Grade		Grades above	33
2	X	80
3	Y	70		Name
4	Z	60		X
5	P	32		Y
6	H	20		Z
7	J	45		J
8	N	90		N
Sheet

 

[kamaruddinjnv]

Thanks a lot. But I was needed formula based.

 

[kamaruddinjnv]

Thanks a lot. It is nicely working. It's great help.

 

[AhoyNC]

You're welcome. Thanks for the feedback.

 

[kamaruddinjnv]

Thanks. It's working nicely but I want name list according to decending order of marks automatically. Is it possible?

 

[AhoyNC]

This should do what you want and will handle duplicate grades.

Formula in D4 below is an array formula and must be entered with CTRL-SHIFT-ENTER.
Drag formulas down as needed.

Excel Workbook
	A	B	C	D	E
1	Name	Grade		Grades above	33
2	X	80
3	Y	70		Name	Grade
4	Z	60		N	90
5	P	80		X	80
6	H	20		P	80
7	J	45		Y	70
8	N	90		Z	60
9				J	45
Sheet