+ Reply to Thread
Results 1 to 2 of 2

0365 excel Filter linked search box returns #Calc empty array error sheet attached.

  1. #1
    Registered User
    Join Date
    02-11-2024
    Location
    omaha
    MS-Off Ver
    365
    Posts
    1

    0365 excel Filter linked search box returns #Calc empty array error sheet attached.

    0365 excel inventory sheet, Filter linked search box returns #CALC! Empty Array error sheet attached. K10 in formula red. formula actually worked until I tried to add Conditional higlight formatting to rows. I have tried new work books and sheets to no avail. Thank you in advance to anyone that can assist me.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,065

    Re: 0365 excel Filter linked search box returns #Calc empty array error sheet attached.

    Welcome to the forum! There is a #REF! error in your formula: =(FILTER(A2:A595,ISNUMBER(SEARCH(K14,#REF!))))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 05-27-2023, 05:55 PM
  2. Getting #CALC! error from using FILTER function
    By mikehk in forum Excel General
    Replies: 1
    Last Post: 11-28-2020, 10:26 PM
  3. [SOLVED] VLOOKUP returns error when table array is from another sheet - Excel settings?
    By zak1914 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-06-2020, 02:40 PM
  4. [SOLVED] Using macro to find first empty cell in column. If range is empty returns error.
    By A440 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-23-2019, 11:03 AM
  5. Query on Excel sheet returns error, how to prevent error message
    By rgsbouma in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-02-2019, 01:38 PM
  6. SEARCH function returns array if first argument is array--Huh?
    By 6StringJazzer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2012, 07:23 PM
  7. Replies: 2
    Last Post: 02-28-2006, 01:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1