Hi there,
I have two columns , student and mark . I want to select the students who have a mark of greater than 70. Is this the right way to do it ?
Hi there,
I have two columns , student and mark . I want to select the students who have a mark of greater than 70. Is this the right way to do it ?
1. Select A1:B1
2. Go to Data:Filter:AutoFilter
3. Select the arrow on B1: Custom Filter
4. Select "Greater than or equal to"
5. Type 70 on the corresponding slot.
Does that help?
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks