+ Reply to Thread
Results 1 to 4 of 4

Filter Function Returning #Value! Error

  1. #1
    Forum Contributor
    Join Date
    05-12-2013
    Location
    Australia
    MS-Off Ver
    Microsoft Office 365
    Posts
    136

    Filter Function Returning #Value! Error

    Hi,
    A2:C8 extract the scores of all females with a GA h'cap<=20 from cols H-S, but returns a #Value! error if the number of rows exceed the field size.
    How can this be overcome?
    Thanking you in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2504 and WPS V2024(12.1.0.18543)
    Posts
    4,048

    Re: Filter Function Returning #Value! Error

    Pls try this formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    05-12-2013
    Location
    Australia
    MS-Off Ver
    Microsoft Office 365
    Posts
    136

    Re: Filter Function Returning #Value! Error

    Thanks for the fix.
    Cheers!

  4. #4
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2504 and WPS V2024(12.1.0.18543)
    Posts
    4,048

    Re: Filter Function Returning #Value! Error

    @Ian McPherson You're Welcome. Glad to help . Thank You for the feedback and rep.

+ 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. Returning a zero if_empty in a nested FILTER Function
    By kingkevbo in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-14-2023, 10:25 AM
  2. [SOLVED] Filter function not returning multple values
    By Svey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2021, 08:10 AM
  3. FILTER Function only returning top 10 results?
    By Shodan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2021, 10:27 AM
  4. IF function returning error
    By rehan0129 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-10-2018, 10:05 AM
  5. [SOLVED] Advanced filter returning all dates instead of those in criteria range, or error
    By nemmy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-03-2016, 02:45 PM
  6. [SOLVED] VBA Filter Function Returning Same Values
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-10-2015, 02:47 AM
  7. VBA Function Returning #VALUE! Error
    By GazB in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-23-2013, 04:16 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