DATA ADVANCE FILTER

Dosto pichhli kuch post me mein aapko advance excel ke baarey me kafi kuch bata chuka hu, jaise ki H Lookup, V Lookup, Data Sort & filter etc yeh sab aap niche popular post me dekh sakte hai. Dosto aaj ki post me aapko Advance filter ki jaankari dene ki koshish karunga.
Advance filter ka use table me kisi ek criteria ke hisab se filter karna hota hai, to chaliye dosto step by step jaante hai ki iska use kaise hota hai.

Step 1

Table

Sabse pehle hum ek table banayenge aur filter lagane ke liye uska criteria bhi set karenge, jaise niche image me kuch naam diye hai, naam ke aage unki designations aur uske samne unki salary di gayi hai.

Step 2

Criteria

Iske baad filter ka criteria set karenge niche image criteria ke according designation OFFICER ke saath jitni rows me SALARY di gayi hai unme se 5000 se adhik (>5000) kon kon si hai, un sabhi salary ko show karega.

Step 3

Ab aapko niche diye gaye steps follow karne hai, 1. Advance filter par click kare 2. copy to another location par click karne se jaha aap chahe vaha result show hoga, 3. list range me table ko select karna hai, 4. criteria range me criteria ko select karna hai, 5. copy to ka use karte hua aap jaha par click karenge vahi par result show hoga.

Step 4

Ab niche image me aapko result show ho gaya hoga, jiska matlab hai jitne bhi officer rank ke names yaha show ho rahe hai un sab ki salary 5000 se above hai, Yeh filter hum kisi bhi designation ke saath use kar sakte hai.

Dosto yeh post aapko kaisi lagi comment karke apna feedbak jaroor dijiye.

Ramesh Singh

Hello Dosto ! Mera Naam Ramesh Singh Hai. Main Ek Passionate Blogger Hun. Ye Website Maine Banai Hai. Is Website Par Main Longo Ko Hindi Me Jankari Deta Hun Aur Unki Help Karta Hun. Read More

Leave a Reply

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