{"id":379,"date":"2026-04-23T04:20:16","date_gmt":"2026-04-23T03:20:16","guid":{"rendered":"https:\/\/nikasoftware.com\/?p=379"},"modified":"2026-04-23T07:56:43","modified_gmt":"2026-04-23T06:56:43","slug":"filter-formula-in-excel","status":"publish","type":"post","link":"https:\/\/nikasoftware.com\/index.php\/2026\/04\/23\/filter-formula-in-excel\/","title":{"rendered":"Filter Formula in Excel"},"content":{"rendered":"\n

Excel \u092e\u0947\u0902 FILTER Function \u0915\u094d\u092f\u093e \u0939\u0948? (\u092c\u093f\u0932\u094d\u0915\u0941\u0932 \u0906\u0938\u093e\u0928 \u092d\u093e\u0937\u093e \u092e\u0947\u0902 \u0938\u0940\u0916\u0947\u0902)<\/strong><\/p>\n\n\n\n

\u0906\u091c\u0915\u0932 \u0921\u0947\u091f\u093e \u0915\u0947 \u0938\u093e\u0925 \u0915\u093e\u092e \u0915\u0930\u0928\u093e \u092c\u0939\u0941\u0924 \u0906\u092e \u0939\u094b \u0917\u092f\u093e \u0939\u0948\u0964 \u0905\u0917\u0930 \u0906\u092a Excel \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902, \u0924\u094b \u0906\u092a\u0928\u0947 \u0915\u092d\u0940 \u0928 \u0915\u092d\u0940 \u090f\u0915 \u092c\u0921\u093c\u0940 \u0932\u093f\u0938\u094d\u091f \u092e\u0947\u0902 \u0938\u0947 \u0905\u092a\u0928\u0947 \u0915\u093e\u092e \u0915\u0940 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0922\u0942\u0901\u0922\u0928\u0947 \u092e\u0947\u0902 \u0938\u092e\u092f \u091c\u0930\u0942\u0930 \u092c\u0930\u094d\u092c\u093e\u0926 \u0915\u093f\u092f\u093e \u0939\u094b\u0917\u093e\u0964 nikasoftware.com \u0915\u0947 \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947\u0902, \u0939\u092e \u0906\u092a\u0915\u094b Excel \u0915\u0947 \u090f\u0915 \u092c\u0947\u0939\u0926 \u0936\u093e\u0928\u0926\u093e\u0930 \u0914\u0930 \u0928\u090f \u092b\u0940\u091a\u0930 \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u092c\u0924\u093e\u0928\u0947 \u091c\u093e \u0930\u0939\u0947 \u0939\u0948\u0902, \u091c\u094b \u0906\u092a\u0915\u093e \u0918\u0902\u091f\u094b\u0902 \u0915\u093e \u0915\u093e\u092e \u092e\u093f\u0928\u091f\u094b\u0902 \u092e\u0947\u0902 \u0915\u0930 \u0926\u0947\u0917\u093e\u0964 \u0907\u0938 \u092b\u0940\u091a\u0930 \u0915\u093e \u0928\u093e\u092e \u0939\u0948 – FILTER Function<\/strong>\u0964<\/p>\n\n\n\n

FILTER \u092b\u093c\u0902\u0915\u094d\u0936\u0928 \u0905\u0938\u0932 \u092e\u0947\u0902 \u0915\u094d\u092f\u093e \u0915\u0930\u0924\u093e \u0939\u0948?<\/strong><\/p>\n\n\n\n

\u0907\u0938 \u092b\u0949\u0930\u094d\u092e\u0942\u0932\u0947 \u0915\u094b \u0906\u092a \u0905\u092a\u0928\u0947 \u0918\u0930 \u0915\u0940 \u091a\u093e\u092f \u0915\u0940 \u091b\u0932\u0928\u0940 (Strainer) \u0915\u0940 \u0924\u0930\u0939 \u0938\u092e\u091d \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u091c\u092c \u0906\u092a \u091a\u093e\u092f \u091b\u093e\u0928\u0924\u0947 \u0939\u0948\u0902, \u0924\u094b \u0915\u093e\u092e \u0915\u0940 \u091a\u093e\u092f \u0915\u092a \u092e\u0947\u0902 \u0906 \u091c\u093e\u0924\u0940 \u0939\u0948 \u0914\u0930 \u092c\u0947\u0915\u093e\u0930 \u092a\u0924\u094d\u0924\u0940 \u091b\u0932\u0928\u0940 \u092e\u0947\u0902 \u0930\u0939 \u091c\u093e\u0924\u0940 \u0939\u0948\u0964<\/p>\n\n\n\n

Excel \u0915\u093e FILTER \u092b\u093c\u0902\u0915\u094d\u0936\u0928 \u092d\u0940 \u092c\u093f\u0932\u094d\u0915\u0941\u0932 \u092f\u0939\u0940 \u0915\u0930\u0924\u093e \u0939\u0948! \u0906\u092a \u0907\u0938\u0947 \u090f\u0915 \u092c\u0939\u0941\u0924 \u092c\u0921\u093c\u093e \u0921\u0947\u091f\u093e \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u090f\u0915 ‘\u0936\u0930\u094d\u0924’ (Condition) \u092c\u0924\u093e\u0924\u0947 \u0939\u0948\u0902\u0964 \u092f\u0939 \u092b\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u0909\u0938 \u092c\u0921\u093c\u0940 \u0932\u093f\u0938\u094d\u091f \u0915\u094b \u091b\u093e\u0928\u0924\u093e \u0939\u0948 \u0914\u0930 \u0938\u093f\u0930\u094d\u092b \u0935\u0939\u0940 \u0921\u0947\u091f\u093e \u090f\u0915 \u0928\u0908 \u091c\u0917\u0939 \u092a\u0930 \u0928\u093f\u0915\u093e\u0932 \u0915\u0930 \u0930\u0916 \u0926\u0947\u0924\u093e \u0939\u0948, \u091c\u094b \u0906\u092a\u0915\u0940 \u0936\u0930\u094d\u0924 \u0915\u094b \u092a\u0942\u0930\u093e \u0915\u0930\u0924\u093e \u0939\u0948\u0964 \u0906\u092a\u0915\u093e \u092a\u0941\u0930\u093e\u0928\u093e \u0921\u0947\u091f\u093e \u092c\u093f\u0932\u094d\u0915\u0941\u0932 \u0935\u0948\u0938\u093e \u0939\u0940 \u0938\u0941\u0930\u0915\u094d\u0937\u093f\u0924 \u0930\u0939\u0924\u093e \u0939\u0948\u0964<\/p>\n\n\n\n

\u092b\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u0915\u0948\u0938\u0947 \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902?<\/h3>\n\n\n\n

\u0907\u0938\u0915\u093e \u092b\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u092c\u0939\u0941\u0924 \u0939\u0940 \u0906\u0938\u093e\u0928 \u0939\u0948:<\/p>\n\n\n\n

=FILTER(array, include, [if_empty])<\/code><\/p>\n\n\n\n

\u0918\u092c\u0930\u093e\u0907\u090f \u092e\u0924, \u0906\u0907\u090f \u0907\u0928 \u0924\u0940\u0928\u094b\u0902 \u0936\u092c\u094d\u0926\u094b\u0902 \u0915\u093e \u092e\u0924\u0932\u092c \u092c\u093f\u0932\u094d\u0915\u0941\u0932 \u0938\u093e\u0927\u093e\u0930\u0923 \u092d\u093e\u0937\u093e \u092e\u0947\u0902 \u0938\u092e\u091d\u0924\u0947 \u0939\u0948\u0902:<\/p>\n\n\n\n

    \n
  • Array (\u0915\u0939\u093e\u0901 \u0938\u0947 \u0922\u0942\u0901\u0922\u0928\u093e \u0939\u0948?):<\/strong> \u092f\u0939 \u0935\u094b \u092a\u0942\u0930\u0940 \u091f\u0947\u092c\u0932 \u092f\u093e \u0932\u093f\u0938\u094d\u091f \u0939\u0948, \u091c\u093f\u0938\u092e\u0947\u0902 \u0938\u0947 \u0906\u092a\u0915\u094b \u0905\u092a\u0928\u093e \u0921\u0947\u091f\u093e \u091b\u093e\u0901\u091f\u0928\u093e \u0939\u0948\u0964<\/li>\n\n\n\n
  • Include (\u0915\u094d\u092f\u093e \u0922\u0942\u0901\u0922\u0928\u093e \u0939\u0948?):<\/strong> \u092f\u0939 \u0906\u092a\u0915\u0940 ‘\u0936\u0930\u094d\u0924’ \u0939\u0948\u0964 \u091c\u0948\u0938\u0947- \u092e\u0941\u091d\u0947 \u0938\u093f\u0930\u094d\u092b “UPI” \u0935\u093e\u0932\u0947 \u0928\u093e\u092e \u091a\u093e\u0939\u093f\u090f, \u092f\u093e \u0938\u093f\u0930\u094d\u092b \u0935\u094b item \u091a\u093e\u0939\u093f\u090f \u091c\u093f\u0928\u0915\u0940 \u0915\u0940\u092e\u0924 1000 \u0930\u0941\u092a\u092f\u0947 \u0938\u0947 \u0915\u092e \u0939\u0948\u0964<\/li>\n\n\n\n
  • [If_empty] (\u0905\u0917\u0930 \u0915\u0941\u091b \u0928 \u092e\u093f\u0932\u0947 \u0924\u094b \u0915\u094d\u092f\u093e \u0915\u0930\u0947\u0902?):<\/strong> \u092e\u093e\u0928 \u0932\u0940\u091c\u093f\u090f \u0906\u092a\u0928\u0947 \u091c\u094b \u0936\u0930\u094d\u0924 \u0932\u0917\u093e\u0908, \u0909\u0938 \u0939\u093f\u0938\u093e\u092c \u0938\u0947 \u0932\u093f\u0938\u094d\u091f \u092e\u0947\u0902 \u0915\u094b\u0908 \u0921\u0947\u091f\u093e \u0939\u0940 \u0928\u0939\u0940\u0902 \u0939\u0948\u0964 \u0924\u094b Excel \u0906\u092a\u0915\u094b “Error” \u0926\u093f\u0916\u093e\u0928\u0947 \u0915\u0947 \u092c\u091c\u093e\u092f \u0915\u094d\u092f\u093e \u0938\u0902\u0926\u0947\u0936 \u0926\u093f\u0916\u093e\u090f? \u0906\u092a \u092f\u0939\u093e\u0901 \u0932\u093f\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902- “\u0915\u094b\u0908 \u0921\u0947\u091f\u093e \u0928\u0939\u0940\u0902 \u092e\u093f\u0932\u093e”\u0964<\/li>\n<\/ul>\n\n\n\n

    \u090f\u0915 \u0906\u0938\u093e\u0928 \u0909\u0926\u093e\u0939\u0930\u0923 \u0938\u0947 \u0938\u092e\u091d\u0947\u0902 (Sales Data)<\/h3>\n\n\n\n

    \u092e\u093e\u0928 \u0932\u0940\u091c\u093f\u090f \u0906\u092a\u0915\u0940 \u090f\u0915 \u0926\u0941\u0915\u093e\u0928 \u0939\u0948 \u0914\u0930 \u0906\u092a\u0915\u0947 \u092a\u093e\u0938 \u0906\u091c \u0915\u0940 \u0938\u0947\u0932 (Sales) \u0915\u0940 \u090f\u0915 \u0932\u093f\u0938\u094d\u091f \u0939\u0948\u0964 \u0907\u0938 \u0932\u093f\u0938\u094d\u091f \u0915\u0947 \u0915\u0949\u0932\u092e A<\/strong> \u092e\u0947\u0902 ‘\u092c\u093f\u0915\u0947 \u0939\u0941\u090f \u0938\u093e\u092e\u093e\u0928 \u0915\u093e \u0928\u093e\u092e’ (\u091c\u0948\u0938\u0947- \u0936\u0930\u094d\u091f, \u091c\u0940\u0902\u0938, \u091f\u0940-\u0936\u0930\u094d\u091f) \u0939\u0948 \u0914\u0930 \u0915\u0949\u0932\u092e B<\/strong> \u092e\u0947\u0902 ‘\u092a\u0947\u092e\u0947\u0902\u091f \u0915\u093e \u0924\u0930\u0940\u0915\u093e’ (\u091c\u0948\u0938\u0947- Cash, UPI, Card) \u0932\u093f\u0916\u093e \u0939\u0948\u0964<\/p>\n\n\n\n

    \u0905\u092c \u0906\u092a\u0915\u094b \u090f\u0915 \u0928\u0908 \u0932\u093f\u0938\u094d\u091f \u092c\u0928\u093e\u0928\u0940 \u0939\u0948 \u091c\u093f\u0938\u092e\u0947\u0902 \u0906\u092a\u0915\u094b \u0938\u093f\u0930\u094d\u092b \u0909\u0928 \u0938\u093e\u092e\u093e\u0928\u094b\u0902 \u0915\u0947 \u0928\u093e\u092e \u0926\u0947\u0916\u0928\u0947 \u0939\u0948\u0902 \u091c\u093f\u0928\u0915\u0940 \u092a\u0947\u092e\u0947\u0902\u091f “UPI”<\/strong> \u0938\u0947 \u0939\u0941\u0908 \u0939\u0948, \u0924\u093e\u0915\u093f \u0906\u092a \u091a\u0947\u0915 \u0915\u0930 \u0938\u0915\u0947\u0902 \u0915\u093f \u0911\u0928\u0932\u093e\u0907\u0928 \u0915\u093f\u0924\u0928\u0947 \u092a\u0948\u0938\u0947 \u0906\u090f\u0964<\/p>\n\n\n\n

    \u0906\u092a \u0915\u093f\u0938\u0940 \u0916\u093e\u0932\u0940 \u091c\u0917\u0939 \u092a\u0930 \u092f\u0939 \u092b\u093c\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u0932\u0917\u093e\u090f\u0902\u0917\u0947: =FILTER(A1:C9, B1:B9=\"UPI\", \"\u0915\u094b\u0908 UPI \u092a\u0947\u092e\u0947\u0902\u091f \u0928\u0939\u0940\u0902\")<\/code><\/p>\n\n\n\n

    \u092f\u0939 \u092b\u093c\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u0915\u094d\u092f\u093e \u0915\u0930\u0947\u0917\u093e?<\/strong><\/p>\n\n\n\n

      \n
    1. \u092f\u0939 A1 \u0938\u0947 C9 \u0924\u0915 \u0915\u0940 \u092a\u0942\u0930\u0940 \u0938\u0947\u0932 \u0932\u093f\u0938\u094d\u091f (Array) \u092e\u0947\u0902 \u091c\u093e\u090f\u0917\u093e\u0964<\/li>\n\n\n\n
    2. \u092b\u093f\u0930 \u092f\u0939 \u0926\u0947\u0916\u0947\u0917\u093e \u0915\u093f B \u0915\u0949\u0932\u092e (\u092a\u0947\u092e\u0947\u0902\u091f \u0915\u093e \u0924\u0930\u0940\u0915\u093e) \u092e\u0947\u0902 \u0915\u0939\u093e\u0901-\u0915\u0939\u093e\u0901 “UPI” \u0932\u093f\u0916\u093e \u0939\u0948 (Include)\u0964<\/li>\n\n\n\n
    3. \u091c\u0939\u093e\u0901 \u092d\u0940 \u0907\u0938\u0947 “UPI” \u092e\u093f\u0932\u0947\u0917\u093e, \u092f\u0939 \u0909\u0938 \u092a\u0942\u0930\u0947 \u0921\u0947\u091f\u093e \u0915\u094b \u091b\u093e\u0928\u0915\u0930 \u0906\u092a\u0915\u0947 \u0938\u093e\u092e\u0928\u0947 \u090f\u0915 \u0928\u0908 \u091c\u0917\u0939 \u092a\u0930 \u0930\u0916 \u0926\u0947\u0917\u093e\u0964 \u0905\u0917\u0930 \u092a\u0942\u0930\u0947 \u0926\u093f\u0928 \u092e\u0947\u0902 \u0915\u094b\u0908 UPI \u092a\u0947\u092e\u0947\u0902\u091f \u0928\u0939\u0940\u0902 \u0939\u0941\u0908 \u0939\u094b\u0917\u0940, \u0924\u094b \u092f\u0939 “\u0915\u094b\u0908 UPI \u092a\u0947\u092e\u0947\u0902\u091f \u0928\u0939\u0940\u0902” \u0932\u093f\u0916\u093e \u0939\u0941\u0906 \u0926\u093f\u0916\u093e \u0926\u0947\u0917\u093e\u0964<\/li>\n<\/ol>\n\n\n\n

      FILTER Function \u0915\u0947 \u0938\u092c\u0938\u0947 \u092c\u0921\u093c\u0947 \u092b\u093e\u092f\u0926\u0947:<\/h3>\n\n\n\n
        \n
      • \u0938\u092e\u092f \u0915\u0940 \u092c\u091a\u0924:<\/strong> \u0918\u0902\u091f\u094b\u0902 \u0915\u093e \u0915\u093e\u092e \u0938\u0947\u0915\u0902\u0921\u094b\u0902 \u092e\u0947\u0902 \u0939\u094b \u091c\u093e\u0924\u093e \u0939\u0948\u0964<\/li>\n\n\n\n
      • \u0911\u091f\u094b-\u0905\u092a\u0921\u0947\u091f (Auto-Update):<\/strong> \u0905\u0917\u0930 \u0906\u092a \u0905\u092a\u0928\u0947 \u092e\u0947\u0928 \u0921\u0947\u091f\u093e \u092e\u0947\u0902 \u092c\u093e\u0926 \u092e\u0947\u0902 \u0915\u094b\u0908 \u0928\u092f\u093e ‘Computer’ \u0928\u093e\u092e \u091c\u094b\u0921\u093c\u0924\u0947 \u0939\u0948\u0902, \u0924\u094b \u0935\u0939 \u0907\u0938 \u0928\u0908 \u0932\u093f\u0938\u094d\u091f \u092e\u0947\u0902 \u0905\u092a\u0928\u0947 \u0906\u092a \u091c\u0941\u0921\u093c \u091c\u093e\u090f\u0917\u093e\u0964 \u0906\u092a\u0915\u094b \u092c\u093e\u0930-\u092c\u093e\u0930 \u092b\u093c\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u0932\u0917\u093e\u0928\u0947 \u0915\u0940 \u091c\u093c\u0930\u0942\u0930\u0924 \u0928\u0939\u0940\u0902 \u0939\u0948!<\/li>\n\n\n\n
      • \u0915\u094b\u0908 \u091d\u0902\u091d\u091f \u0928\u0939\u0940\u0902:<\/strong> \u092a\u0941\u0930\u093e\u0928\u0947 \u0921\u0947\u091f\u093e \u0915\u094b \u092c\u093f\u0928\u093e \u091b\u0947\u0921\u093c\u0947, \u0906\u092a\u0915\u094b \u090f\u0915 \u0938\u093e\u092b\u093c-\u0938\u0941\u0925\u0930\u0940 \u0928\u0908 \u0932\u093f\u0938\u094d\u091f \u092e\u093f\u0932 \u091c\u093e\u0924\u0940 \u0939\u0948\u0964<\/li>\n<\/ul>\n\n\n\n

        (\u0928\u094b\u091f: \u092f\u0939 \u092b\u093c\u0902\u0915\u094d\u0936\u0928 Excel 365, Excel 2021 \u0914\u0930 \u0935\u0947\u092c \u0915\u0947 \u0932\u093f\u090f Excel \u092e\u0947\u0902 \u0915\u093e\u092e \u0915\u0930\u0924\u093e \u0939\u0948\u0964)<\/em><\/p>\n\n\n\n

        <\/p>\n","protected":false},"excerpt":{"rendered":"

        Excel \u092e\u0947\u0902 FILTER Function \u0915\u094d\u092f\u093e \u0939\u0948? (\u092c\u093f\u0932\u094d\u0915\u0941\u0932 \u0906\u0938\u093e\u0928 \u092d\u093e\u0937\u093e \u092e\u0947\u0902 \u0938\u0940\u0916\u0947\u0902) \u0906\u091c\u0915\u0932 \u0921\u0947\u091f\u093e \u0915\u0947 \u0938\u093e\u0925 \u0915\u093e\u092e \u0915\u0930\u0928\u093e \u092c\u0939\u0941\u0924 \u0906\u092e \u0939\u094b \u0917\u092f\u093e \u0939\u0948\u0964 \u0905\u0917\u0930 \u0906\u092a Excel \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902, \u0924\u094b \u0906\u092a\u0928\u0947 \u0915\u092d\u0940 \u0928 \u0915\u092d\u0940 \u090f\u0915 \u092c\u0921\u093c\u0940 \u0932\u093f\u0938\u094d\u091f \u092e\u0947\u0902 \u0938\u0947 \u0905\u092a\u0928\u0947 \u0915\u093e\u092e \u0915\u0940 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0922\u0942\u0901\u0922\u0928\u0947 \u092e\u0947\u0902 \u0938\u092e\u092f \u091c\u0930\u0942\u0930 \u092c\u0930\u094d\u092c\u093e\u0926 \u0915\u093f\u092f\u093e \u0939\u094b\u0917\u093e\u0964 nikasoftware.com \u0915\u0947 \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947\u0902, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[24],"tags":[],"class_list":["post-379","post","type-post","status-publish","format-standard","hentry","category-ms-excel-tips-and-tricks"],"_links":{"self":[{"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/posts\/379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/comments?post=379"}],"version-history":[{"count":4,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/posts\/379\/revisions"}],"predecessor-version":[{"id":723,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/posts\/379\/revisions\/723"}],"wp:attachment":[{"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/media?parent=379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/categories?post=379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nikasoftware.com\/index.php\/wp-json\/wp\/v2\/tags?post=379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}