Display only conditional items line wise

January 19, 2012 at 07:25:14
Specs: Windows 7
i have an excel file having names marks and % ,in the adjacent column i want to display only the names whose % is more than 50 one cell after another ,the names of the students having less than 50 should not appear.Kindly help me with a formula for the same.
Thanks in advance

See More: Display only conditional items line wise

Report •

January 19, 2012 at 13:54:08
Your looking for AutoFiltering
try here for a good tutorial:




Report •

January 19, 2012 at 19:50:34
Thank u but i am looking for a formula that gives me the result in the adjacent cell without having to use filters

Report •

January 20, 2012 at 05:26:49
The closest I could find was the method shown in the video I've linked to below. This method requires 2 criteria to create a list.

You have 2 options:

1 - Use a "helper column" with a second criteria that will always be true. You could even hide this column so it won't be "distracting".

2 - Keep searching through this gentleman's Excel Magic Tricks until you find one that only uses 1 criteria.

As you'll see from the video, keep in mind that trying to use formulas in places where Filters were designed to be used is pretty complicated. Even the author mentions that in some of his videos.

If you set up an Advanced Filters correctly, you can enter your criteria in a single cell and the filter will update automatically.

However, if you really want a formula method, watch this video:

Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question