Feedback by UserVoice

Pip

My feedback

  1. 16 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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 →
    Pip supported this idea  · 
  2. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  3. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  4. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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.

  5. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  6. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Pip supported this idea  · 
  7. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  8. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  9. 184 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Pip supported this idea  · 
  10. 337 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Pip supported this idea  · 
  11. 318 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Pip supported this idea  · 
  12. 1,267 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thanks for the suggestion and for the support of this feature. If you meant to vote for the Data Form, which is different than VBA UserForms, please change your vote to that suggestion instead. From reading the comments on this one, it seems that some clarification was needed.

    I updated the title and description for this one and we’ll continue to monitor for comments and votes.

    Here’s the link to the Data Form suggestion – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17930662-restore-data-form-functionality

    Steve K [MS Excel]

    Pip supported this idea  · 
  13. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  14. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  15. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  16. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  17. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Excel for Mac » Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
    Pip supported this idea  · 
  18. 18 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  19. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Performance  ·  Flag idea as inappropriate…  ·  Admin →
    Pip shared this idea  · 
  20. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 

    If you always want it to round up, use ROUNDUP()

← Previous 1

Feedback and Knowledge Base