CHAPTER 14 · ADVANCED EXCEL

Dynamic Arrays: FILTER, SORT & UNIQUE

Modern Excel formulas ek result ke bajay multiple cells me spill ho sakte hain. Dynamic arrays reporting aur data preparation ko kaafi fast banate hain.

English + Hinglish35 minBrowser practice

UNIQUE

distinct valuesExcel

=UNIQUE(A2:A10)

SORT

sorted spillExcel

=SORT(B2:B10)

FILTER

conditional spillExcel

=FILTER(A2:B10,B2:B10>=50)

Result automatically nearby cells me spill hota hai. Spill area blocked ho to #SPILL! error mil sakta hai.

Hinglish

UNIQUE duplicate hata kar list banata hai, SORT order change karta hai aur FILTER condition ke according rows/values return karta hai.

Practice

Excel Lab me UNIQUE, SORT aur FILTER ke compact spill challenges try karo.

Open Excel Lab →