Conditional range

[JHVincent]

Hi,

I need to create a conditional range. If CellValue=n, then includ
cell in range.

Not sure if what I'm asking is right so I'll tell you what I'm tryin
to do:
I have two columns
column A represents month value, column B represents number of day
late.
8 | 5
8 | 0
10 | -2
9 | 3
10 | 0
8 | 2
9 | 1

I want to get the MAX # of days late for month 10 (from example abov
it would be 0), then the MAX days late for month 8(from example abov
it would be 5).

How do I do it?

Thank

 

[NHarkawat]

Use this forumla
=max(if(a1:a10=8,b1:b10) array entered (using ctrl+shift+enter)

 

[Frank Kabel]

Hi
try the following array formula (entered with CTRL+sHIFT+ENTER):
=MAX(IF(A1:A20=10,B1:B10))

 

[mzehr]

Hi,
One way is to use an array enter the following formula using Shift-Ctrl-Enter
=MAX((A1:A7=10)*(B1:B7))