Hi

By linked group do you mean a named range?

If so
=COUNTA(your_range)
=MAX(your_range)

Regards

Roger Govier


Kanaski79 wrote:
I am looking for a way to count how many cells are in a linked group. Then
using this as a range starting at the first cell in the liked group (but a
different column) find the greatest number in the range of cells.