Pip
My feedback

16 votesPip supported this idea ·

5 votesPip supported this idea ·

7 votesPip supported this idea ·

2 votes
An error occurred while saving the comment 
3 votes
An error occurred while saving the comment Pip commentedIn 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 · 
17 votes3 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Pip supported this idea ·

7 votesPip supported this idea ·

3 votesPip supported this idea ·

184 votes24 comments · Excel for Mac » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
Thanks for this suggestion. The FORECAST.ETS functions are available in version 16.x of Excel for Mac. We will continue to monitor this suggestion and prioritize it as appropriate with the other suggestions here.
Steve K [MS Excel]
Pip supported this idea · 
337 votes111 comments · Excel for Mac » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
Thanks for all your comments and votes supporting this suggestion. Please keep adding votes. We are considering this for a future update.
Thanks – Steve K [MS Excel]
Pip supported this idea · 
318 votes62 comments · Excel for Mac » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
Thanks for the suggestion and the votes about 3D maps. We will continue to monitor the suggestion and prioritize it accordingly.
Steve K [MS Excel]
Pip supported this idea · 
1,267 votes
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/304933excelformac/suggestions/17930662restoredataformfunctionality
Steve K [MS Excel]
Pip supported this idea · 
3 votes
An error occurred while saving the comment Pip commentedGreat idea  TEXTSPLIT() perhaps to compliment TEXTJOIN()
Pip supported this idea · 
9 votes
An error occurred while saving the comment Pip commentedI've realised that the new FILTER() function can be used for this:
UNIQUE(FILTER(ARRAY, ARRAY <> ""))
Which works very well!
Pip shared this idea · 
9 votesPip supported this idea ·

7 votesPip supported this idea ·

13 votesPip supported this idea ·

18 votesPip supported this idea ·

2 votesPip shared this idea ·

1 vote
An error occurred while saving the comment Pip commentedIf you always want it to round up, use ROUNDUP()
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.