Feedback by UserVoice

# Pip

1 vote

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

An error occurred while saving the comment
Pip commented  ·

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

Pip supported this idea  ·

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

Pip supported this idea  ·

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

Pip supported this idea  ·

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

Pip supported this idea  ·

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

Pip supported this idea  ·

## We're glad you're here

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.

## We're glad you're here

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  ·

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

Pip supported this idea  ·

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

Pip supported this idea  ·

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

Pip supported this idea  ·

## We're glad you're here

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  ·

## We're glad you're here

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  ·

## We're glad you're here

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  ·

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

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.

Pip supported this idea  ·

## We're glad you're here

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  ·

## We're glad you're here

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  ·

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

Pip supported this idea  ·

## We're glad you're here

Signed in as (Sign out)

We’ll send you updates on this idea

Pip supported this idea  ·