Return maximum whole number from column of data

[Frog1]

Greetings All!

I have a column of data (column A) in which there are whole numbers (1,2,3...etc) and other numbers that may be negative and contain decimal points. I attach a sample of the data. Can someone help with an excel formula that would return the maximum whole number and NOT to include any negative number or that contains a decimal point and then add '1' to this maximum number and paste it below the data column of interest. eg from the sample data the maximum whole number value is '7' [from row 53] -- therefore I wish to insert the number '8' into cell A61. One may notice that the data column follows a similar pattern: there is a 'blank' cell followed by a whole number then three more 'blank' cells then a varying number of cells that contain negative numbers and/or numbers with decimal points, then a blank cell and the pattern is repeated. NB these are blank cells are not empty but contain a formula. I hope I have managed to explain the question clearly and....oh yes "A Happy New Year"

	A
1
2	1
3
4
5
6	3.26
7	7.806
8
9	2
10
11
12
13	-0.74
14	2.413
15	13.04
16	10.72
17
18	3
19
20
21
22	13.98
23	-0.08
24	6.376
25	16.54
26	11.94
27
28	4
29
30
31
32	10.05
33
34	5
35
36
37
38	24.93
39	9.227
40	5.226
41	-1.7
42
43	6
44
45
46
47	-2.94
48	3.71
49	6.15
50	3.744
51	5.092
52
53	7
54
55
56
57	9.77
58	6.466
59	11.36
60
61

 

[Frog1]

Hello Kaper and Hagia (hope I got that right)

The "all in one" formula didnt work as I kept on getting a '#value' error. However the 'Aggregate' formula with a subtle adjustment worked well. I should have mentioned when I posted the question that the data in the column A was related to other cells with specific formula (a bit too complicated to fully explain). Also, though I had only illustrated one column of data with 7 similar patterns (as in the column A) there were other columns of data with 12 and 16 similar patterns. So it was a generic formula that I was after. As In said the Aggregate formula was fine.....thank you all for the help.

Frog1