Advanced Filter in excel in Hindi – Advanced Excel Tutorial in hindi – Auto VS Advanced filter



advanced filter in excel in hindi MS EXCEL 2007 2010 2016 & 2013 – ADVANCED FILTER की मदद से Data को Filter करना with 5 Different examples – Filter and Advanced filter में क्या फर्क है auto filter vs advanced filter – how to use filter the list in place and copy to another location features of advanced afilter detailed explanation. advanced excel.

The advanced filter feature in MS Excel helps the user analyze worksheet data based on…

38 thoughts on “Advanced Filter in excel in Hindi – Advanced Excel Tutorial in hindi – Auto VS Advanced filter

  1. hi deepak ive done the searchable dropdown list from yourvideo it works fine. but i have one problem i want the searchable droplist in one sheet and all my details are in nother sheet what formula can i use for that, hope to hear from you soon.

  2. Good. How to convert date formats without changing date (e.g..D.O.B) in desired format few people maintain their own style e.g..(1.4.1985, 15-July-89, 13/09/1988). How to get as dd mmm yyyy.

  3. Dear Sir,
    I get this question set from a book and it's very confusing to solve.
    I found a formula in solution, but it does not work for me. I need guidance to solve this,
    Thanks in advance.
    Q.3) Create following table in 'Games' sheet of 'Aug2014' workbook, then, perform the tasks as instructed below.
    Name Played Won Draw Lost Goals for Goals Against Points Result
    Bohemians 13 3 8 2 22 14
    Cork City 13 8 1 4 20 11
    Derry City 13 5 4 4 17 13
    Drogheda United 13 0 3 10 8 31
    Dundalk 13 5 4 4 17 16
    Finn Harps 13 6 2 5 20 18
    Kilkenny City 13 1 1 11 9 33
    Shamrock Rovers 13 6 3 4 19 14
    Shelbourne 13 8 2 3 27 14
    Sligo Rovers 13 3 7 3 22 22
    St. Pratricks' Athletic 13 8 4 1 19 10
    U.C.D. 13 3 5 5 12 15
    a) Calculate the points awarded to each team if they get 3 points for a win and 1 pint for a draw. Also, there is 0.5 points for each lost.
    b) Sort the data descending based on Lost and then Draw column.
    c) Apply formula to display "Next Round" for the top 5 teams based on Points and "Eliminated" for others.

Leave a Reply

Your email address will not be published. Required fields are marked *