Feedback by UserVoice

 

Patrick Matthews

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Add a Split dynamic array function

    282 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    30 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Patrick Matthews commented  · 

    The workaround to use FILTERXML is absolutely brilliant! That said...please do give us a real Split function, similar to the one in VBA. And yes, please do give us those optional 3rd and 4th arguments to limit the number of "splits" performed, and/or control the case-sensitivity.

    Patrick Matthews supported this idea  · 

  2. Please create a FILTERJSON (FILTROJSON) worksheet function

    91 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    9 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Patrick Matthews supported this idea  · 

  3. Give us a proper ITERATION or INSTANCE function for duplicates

    26 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Patrick Matthews supported this idea  · 

Feedback and Knowledge Base

(thinking…)