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
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

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</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
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

<tbody>
</tbody>

1​