I've got a column in which each cell has a formula linking to a different worksheet.
The cells can either display a positive number (not 0) or N/A
Row 2 of each column has: (in this example for column B)
=MAX(B3:B10000) (10000 to allow it to automatically update as new rows are added)
But because some cells have N/A, MAX also displays #N/A rather than just ignoring them and displaying the largest integer in the column.
Any way round this?
Thanks
Hugh
The cells can either display a positive number (not 0) or N/A
Row 2 of each column has: (in this example for column B)
=MAX(B3:B10000) (10000 to allow it to automatically update as new rows are added)
But because some cells have N/A, MAX also displays #N/A rather than just ignoring them and displaying the largest integer in the column.
Any way round this?
Thanks
Hugh