Compressing multiple functions across an array into one cell

[Nick Sabo]

Hiya, I just had a question I hoped you all might be able to answer.
currently have a formula I would like to have repeat across severa
cells in an array, and I've done that by making a whole other set o
cells with the results in them. Then I take the second set of cells an
use the MAX() function to find the maximum value of them.

What I would LIKE to do is compress all of that down into one function
so it runs the formula on every cell across the row in the array, the
finds the max value in that row.

Any idea how or whether that can be done

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Living the Dream]

Hi Nick

I have a length of string.

Can you guess how long it is from where you sit...

You are going to have to give us something more in order to get a result
for you.

Paste your formula(s)
Some sheets names or at least some ranges and or sample data and an
example of your expected result would be nice...

Cheers
Mick.

 

[Nick Sabo]

Hi Nick

I have a length of string.

Can you guess how long it is from where you sit...

You are going to have to give us something more in order to get a resul

for you.

Paste your formula(s)
Some sheets names or at least some ranges and or sample data and an
example of your expected result would be nice...

Cheers
Mick.

I pasted the whole workbook I'm using one post before this post, alon
with an explanation of what I was looking for

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Living the Dream]

Nick

You can't attach files in NG's, you have to use a File Sharing website
eg www.ExcelBanter.com, it is an excel forum that allow attachments..

HTH
Mick.

 

[Nick Sabo]

Nick

You can't attach files in NG's, you have to use a File Sharing website
eg www.ExcelBanter.com, it is an excel forum that allow attachments..

HTH
Mick.

Again, I didn't post this in a newsgroup, it was posted on ExcelBanter
three posts above this one

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[plinius]

Il 17/09/2012 12:31, Nick Sabo ha scritto:

Again, I didn't post this in a newsgroup, it was posted on ExcelBanter,
three posts above this one.


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

In Y4 put:
=MAX(--SUBSTITUTE(SUBSTITUTE(C4:L4,"<",""),"-",0))
(matricial formula, to confirm by CTRL+SHIFT+RETURN)

 

[Nick Sabo]

In Y4 put
=MAX(--SUBSTITUTE(SUBSTITUTE(C4:L4,"<",""),"-",0)
(matricial formula, to confirm by CTRL+SHIFT+RETURN

Wow, didn't know about SUBSTITUTE(), that's really useful. However, i
still seems not be working, somehow... does it work for you

EDIT: Wow I didn't know about CSE Formulas. That is staggeringly usefu
and completely unintuitive, but thank you, you're amazing

+-------------------------------------------------------------------
+-------------------------------------------------------------------