Advance Excel Assignment XLOOKUP Notes XLOOKUP Formula XMATCH Notes XMATCH Formula FILTER Notes FILTER Formula SORT Notes SORT Formula SORTBY Notes SORTBY Formula UNIQUE (Advanced usage) Notes UNIQUE (Advanced usage) Formula SEQUENCE Notes SEQUENCE Formula RANDARRAY Notes RANDARRAY Formula LET Notes LET Formula LAMBDA Notes LAMBDA Formula MAKEARRAY Notes MAKEARRAY Formula MAKEARRAY (अधिकतम Excel में वही) Notes MAKEARRAY (अधिकतम Excel में वही) Formula SCAN Notes SCAN Formula REDUCE Notes REDUCE Formula BYROW Notes BYROW Formula BYCOL Notes BYROW Formula Notes BYCOL Formula DYNAMICArrayTip: (डायनामिक ऐरेवर्क) Notes DYNAMICArrayTip: (डायनामिक ऐरेवर्क) Formula IFS Notes IFS Formula SWITCH (Advanced) Notes SWITCH (Advanced) Formula XMATCH (Advanced) Notes XMATCH (Advanced) Formula AGGREGATE Notes AGGREGATE Formula OFFSET (Advanced) Notes OFFSET (Advanced) Formula INDIRECT (Advanced) Notes INDIRECT (Advanced) Formula DGET Notes DGET Formula DSUM Notes DSUM Formula DMAX Notes DMAX Formula DMIN Notes DMIN Formula DAVERAGE Notes DAVERAGE Formula DCOUNTA Notes DCOUNTA Formula DCOUNT Notes DCOUNT Formula DPRODUCT Notes DPRODUCT Formula DSTDEV Notes DSTDEV Formula DSTDEVP Notes DSTDEVP Formula DVAR Notes DVAR Formula DVARP Notes DVARP Formula DGET Notes DGET Formula DAVERAGE Notes DAVERAGE Formula