Feedback by UserVoice

Pip

My feedback

  1. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Pip commented  · 

    Use XLOOKUP() instead

  2. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Pip supported this idea  · 
  3. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Pip supported this idea  · 
  4. 21 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Pip supported this idea  · 
  5. 5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Pip supported this idea  · 
  6. 7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Pip supported this idea  · 
  7. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Pip commented  · 

    Maybe have an option when defining the sort order to automatically sort when the data is changed rather than a function to force a sort.

  8. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Pip commented  · 

    In answer to anonymous, see attached file. I have 3 tables (SAMPLE_1, 2 and 3 on tabs T1,2 and 3 respectively). On Sheet1 ARRAY1,2 and 3 use the UNIQUE() function to give unique values of each of the SAMPLE tables. In order to combine these three arrays into a single list, in cell F4 I use this nightmare:

    =IFERROR(INDEX($B$4#, ROWS(F3:$F$3)), IFERROR(INDEX($C$4#, ROWS(F3:$F$3)-ROWS($B$4#)), IFERROR(INDEX($D$4#, ROWS(F3:$F$3)-ROWS($B$4#)-ROWS($C$4#)), "")))

    to combine all the arrays. This has to be copied down to each of the cells in column F, and you hope that as data is added to the three SAMPLE tables that you have copied down into column F for enough rows to cover all the entries. (It's not an array function now, I found a way of doing it without using array functions and MID())

    Then I use SORT() and FILTER() in cell H4 to produce the final result.

    If I had a COMBINE() function to combine arrays, I could simple replace all of the workings on Sheet1 with the following in H4:

    =SORT(COMBINE(UNIQUE(SAMPLE_1[T1]),UNIQUE(SAMPLE_2[T2]),UNIQUE(SAMPLE_3[T3]))

    Pip shared this idea  · 
  9. 19 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Pip supported this idea  · 
  10. 8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Pip supported this idea  · 
  11. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Pip supported this idea  · 
  12. 191 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Pip supported this idea  · 
  13. 367 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Pip supported this idea  · 
  14. 338 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Pip supported this idea  · 
  15. 1,433 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    390 comments  ·  Excel for Mac » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for all your votes and comments about enabling support for UserForms in Excel for Mac.

    With emphasis on enabling more and more capability using Office add-ins in Excel that will work across platforms, we don’t expect to add support for creating and modifying UserForms.

    Please see this article for more information about what you can do in Excel with Office add-ins.
    https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-overview

    Pip supported this idea  · 
  16. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Pip commented  · 

    Great idea - TEXTSPLIT() perhaps to compliment TEXTJOIN()

    Pip supported this idea  · 
  17. 9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Pip commented  · 

    I've realised that the new FILTER() function can be used for this:

    UNIQUE(FILTER(ARRAY, ARRAY <> ""))

    Which works very well!

    Pip shared this idea  · 
  18. 9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Pip supported this idea  · 
  19. 8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Mac » Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
    Pip supported this idea  · 
  20. 18 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
    Pip supported this idea  · 
← Previous 1

Feedback and Knowledge Base