Find the largest number in the column

[hsamadzadeh]

my data is as below:

column 1 column 2
1 1
2 1
1 2
1 3
2 2
2 3
1 4
2 4
1 5
1 ?????

I need a formula to find the largest number+1 in the column2 and fill ????

 

[Jonmo1]

Welcome to the board.
Try

=MAX(B$1:B9)+1

 

[hsamadzadeh]

Thanks Jonmo1
But I need a formula to fill max+1 related to column A.

Welcome to the board.
Try

=MAX(B$1:B9)+1

 

[StephenCrump]

It looks like you have:

B1: =COUNTIF(A$1:A1,A1)

But that's not the way you have described it?

Excel 2010
	A	B
1	1	1
2	2	1
3	1	2
4	1	3
5	2	2
6	2	3
7	1	4
8	2	4
9	1	5
10	1	6
1

 

[hsamadzadeh]

Thank you.
=COUNTIF(INDIRECT("e3:e"&ROW());[@Column16])
is working

It looks like you have:

B1: =COUNTIF(A$1:A1,A1)

But that's not the way you have described it?

Excel 2010

	A	B

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]

</tbody>

1​

 

[hsamadzadeh]

Thank you.
=COUNTIF(INDIRECT("e3:e"&ROW());[@Column16])
is working

It looks like you have:

B1: =COUNTIF(A$1:A1,A1)

But that's not the way you have described it?

Excel 2010

	A	B

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]

</tbody>

1​