Max value across multiple pages in 3D array for all individual rows and columns

[Brandts]

Hi all,

I have multiple 2D array data sets stacked in a 3D array. I want to know the maximum vale for each XY position accross all data sets.

Is there a easy way to do this?

To better explain myself, a simple example:

Data set 1 (page 1 in 3D array):

1   2   3

4   5   6

7   8   9

Data set 2 (page 2 in 3D array)

1   4   7

2   5   8

3   6   9

Data set 3 (page 3 in 3D array):

1   3   6

2   5   8

4   7   9

Wanted result (max values for each xy position):

1   4   7

4   5   8

7   8   9

FYI, the actual data exists out of much more rows, columns and pages.

Thanks in advance!

[Nico011 · Accepted solution]

Hey,

I've got a quick example using your values. It should work for larger sets of data.

I hope this helps.

Nic

[Brandts]

Thanks, this works great.

I also learned something new because I thought "Index Array" could only be used to get a single value. 

[Nico011]

Great!

The Index Array will give you everything that matches the indexes you input. It can be used to take out a single element, a row, a column, a page... as long as you specify the indexes correctly.

Glad this helped!

Nic

[crossrulz · Accepted solution]

Here is a simpler version of Nico011's solution (using autoindexing for the output).

[Brandts]

This one looks indeed a lot easier!

Thank you for your improvement.