What is the function of filter in excel?

Question added by RAJA M ZULQURNAIN KAYANI KAYANI G , Supervisor , CIRIN PHARMACEUTICAL PVT LTD
Date Posted: 2016/12/12

Upvote (0) Views (32) Followers (2) Answers (2) Report Question

by BRIJESH KUMAR , Engineer , NextGen Engineering Solutions

Get required data from large amount of data.

by Ahmad Fahim hasan , Data Mining Specialist , Method corp

to get up-to-data results, or clear a filter to re display all of the data.

What is advanced function filter?
Top Answer: It is the AND, OR and Formula as criteria to display the records that meet the criteria. See More

Answers (2)
If you want to print something from excel and you want to repeat the first top columns, which function of Excel you would use?
Top Answer: use Page Layout TAB --- Print Title select Row or Column range (row repeate at top or column to repeate ... See More

Answers (4)
What is the use of "MATCH" and "INDEX" function in excel, please give example.
Top Answer: It is like Vlookup The INDEX function can return an ite ... See More

Answers (1)
What is "VLOOKUP" function in excel?
Top Answer: Vlookup is a very powerful formula. If used correctly it can help you search a value and retrieve a parti ... See More

Answers (4)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.