Return highest value, except from one cell i same column

**Hjahren** · 10-26-2010, 09:06 AM

Hello!

Do anyone of you know how to return the highest value from a column, excluding value in one cell?

The adress are defined in the macro:
Adress2 = c3
Adress1=c24
Adress0 = c6

Please Login or Register  to view this content.

**romperstomper** · 10-26-2010, 09:21 AM

You can use the Union operator to join the cells above the excluded cell to the cells below and then use Max on that.

**Hjahren** · 10-26-2010, 09:40 AM

Could you please help me with that? I don't know what to write

**Hjahren** · 10-26-2010, 09:50 AM

The problem is that these cells will change as I run the macro through all the rows

**romperstomper** · 10-26-2010, 09:54 AM

The real problem is that you haven't really told us what you are doing.
You will need two start addresses and two stop address, then you can use something like:

Please Login or Register  to view this content.

and take the max of that. You might also be able to do it using Evaluate if there is some consistency to the layout, but this is all guesswork currently.