Graham C1600
Board Regular
- Joined
- Feb 17, 2018
- Messages
- 96
- Office Version
- 365
Hi,
Can somebody confirm the easiest way to find the maximum number in an excel column. The data in the column is filtered and there are also some Vlookup returns in the column so the columns will look something like this :-
[TABLE="width: 169"]
<tbody>[TR]
[TD]10[/TD]
[/TR]
[TR]
[TD]8[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]5[/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]31[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]2
The length of the column is about 500 rows.
Thanks for any support on this issue.[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
Can somebody confirm the easiest way to find the maximum number in an excel column. The data in the column is filtered and there are also some Vlookup returns in the column so the columns will look something like this :-
[TABLE="width: 169"]
<tbody>[TR]
[TD]10[/TD]
[/TR]
[TR]
[TD]8[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]5[/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]31[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]2
The length of the column is about 500 rows.
Thanks for any support on this issue.[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]