dynamic address for the range of data

[masoud12]

I have a column of numbers as first row of the range (in “M” column) and another column of numbers as last row number of the range (in N column) in an excel file for the specified column of data (as J column). I want to write the maximum in this range (e.g. J(M2):J(N2) (m2 and n2 are4 row numbers for j column)) in the same row that first and last row of rang specified in another column( column O).

 

[masoud12]

no there is no formula in my file

 

[Peter_SSs]

So, this question still stands

.. but is my data realistic?

If my data is realistic, why should result be A7 or 3? Please clarify the logic.

 

[masoud12]

i mean your formula just get the data in the last row of the range and not the maximum of data in the range.

 

[Peter_SSs]

Perhaps this then?

23 07 30.xlsm
	A	B	C	D
1
2	0		3	6
3	6		3	6
4	8		4	8
5	5		6	5
6	4		6	5
7	3		8	3
8	1		8	3
9	7		9	7
masoud12

Cell Formulas
Range	Formula
D2:D9	D2	=AGGREGATE(14,6,A$2:A$9/(C$2:C$9=C2),1)

 

[masoud12]

thank you Dear Peter

 

[Peter_SSs]

Cheers.