Feedback by UserVoice

# Pip

1. ## Data Validation to hold New dynamic Arrays function in Validation list

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  ·
2. ## The ability to copy (or paste) 'visible cells only' when copying/pasting from a filtered range into a column of empty cells

5 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  ·
3. ## Reapply Filter

7 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  ·
4. ## We need a "SORT" function to automatically sort rows or columns.

2 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

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. ## Combine Arrays Function: COMBINE(Array1, Array2 , ...)

3 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

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. ## Create Array that joins two arrays

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. ## PowerQuery data refresh from SharePoint Online CSV file

7 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  ·
8. ## View (All) option (like Word) to see all white-space characters, training spaces, new-lines, etc.

3 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  ·
9. ## Make available the forecast tool since that is needed for several statistical analysis

184 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

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  ·
10. ## Add Find all in the Mac app

338 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

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  ·
11. ## Add 3D Map / Power Map to Mac Excel 2016

319 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

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  ·
12. ## Enable VBA Support for creating and editing UserForms (not the Data Form)

1,280 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

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. ## Parse

3 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

An error occurred while saving the comment
Pip commented  ·

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

Pip supported this idea  ·
14. ## Have UNIQUE() optionally ignore blanks

9 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

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. ## Chapter Creation

9 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  ·
16. ## Multiple O365 accounts and Excel 15 for MacOS

7 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  ·
17. ## Independent filter/searches in excel on line for multiple users

13 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  ·
18. ## Enable Excel for Mac to connect to list data in SharePoint Online

18 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  ·
19. ## CALCULATE(sheet, on/off/calc)

2 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Pip shared this idea  ·
20. ## Rounding issue with Excel and dollar values

1 vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

An error occurred while saving the comment
Pip commented  ·

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

← Previous 1