Finding minimum of the set of every eighth cell in an array

[mgerada]

Hi excel gurus

I am at a loss and need some excel counselling...

I have a speadsheet which has repeating blocks of data every 10 columns. What I would like to retrieve is the minimum value from the contents of every eighth column.

So if data is as follows:

...............First block of 10 columns A-J......Second block of 10 columns K-T.......Third block of 10 columns U-AD.................Fourth block of 10 columns etc

Cols [A...B...C...D...E...F...G...H...I...J]...[K...L...M...N...O...P...Q...R...S...T]...[U...V...W...X...Y...Z...AA...AB...AC...AD]...[AE....etc....

Row 1 4...3...0...8...6...9...3..(7)..9...5....5...2....7...3....8...5...9..(2)..3...6.....5...7...9....8....2...3....5.....(4).....7.....1.......8.....etc....

where the numbers in brackets are the eighth cell in the block of ten columns....

I want to find the minimum of the set {7,2,4,...etc.....}

Any insights will be greatly appreciated.

Many thanks in anticipation.

mgerada

[dilipandey]

Hi mgerada,

An array formula will help here, but would appreciate if you can share the sample file which will give a quick opportunity for practical tries. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[mgerada]

Hi dilipandey

I have attached a file in which I have repeating sales A to J and I only need the formula for cell B5 which retrieves the minimum sale for all the Sale H. Hope this helps.

Thanks

mgerada

[dilipandey]

Hi mgreada,

See the attached file and let me know if this is what you were looking for. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[mgerada]

Hi mgreada,

See the attached file and let me know if this is what you were looking for. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi dilipandey

You're a genius!!

Many thanks for your asssitance.

Regards

mgerada

[dilipandey]

You are welcome mgerada....

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>