Right, for illustration purposes I have two columns:
A B<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
1 18<o></o>
1 18<o></o>
1 20<o></o>
0 28<o></o>
1 30 <o></o>
0 25<o></o>
<o> </o>
I use column one to define "include" (1) and "exclude" (0). I want to set up a formula that returns the largest number in column B, provided that this row is included (i.e. corresponding cell in A column is 1). I have tried vlookup and with a max function nested but I only get back the first number in column B.<o></o>
<o> </o>
Any suggestions would be much appreciated.<o></o>
A B<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>1 18<o
></o>1 18<o
></o>1 20<o
></o>0 28<o
></o>1 30 <o
></o>0 25<o
></o><o
> </o>I use column one to define "include" (1) and "exclude" (0). I want to set up a formula that returns the largest number in column B, provided that this row is included (i.e. corresponding cell in A column is 1). I have tried vlookup and with a max function nested but I only get back the first number in column B.<o
></o><o
> </o>Any suggestions would be much appreciated.<o
></o>
