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

Your looking for AutoFiltering

try here for a good tutorial:http://www.microsoft.com/canada/sma...

MIKE

Thank u but i am looking for a formula that gives me the result in the adjacent cell without having to use filters

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

http://www.youtube.com/watch?v=NbP-...

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

Ask Your Question

Weekly Poll