L
Lee Grant
Hi there,
I have a column of values (E3:E50) and I want to list below this column, in
a cell (lets say E52) the SUM of the top 5 highest values.
The glitch (as there always is one) is that I don't want every cell to be
considered - I only want, for example, E5, E8, E11, E14, E17, E20, E23, E26,
E29, E32, E35, E38, E41, E44, E47 & E50 to be included.
Is there a way to do this?
Whilst I mention it - would there be a way, with conditional formatting
perhaps, that any cell in that selection (E5, E8, E11, etc.) that IS a top 5
value - could it become a different colour?
Any help would really be appreciated.
Many thanks,
Cheers
Lee
I have a column of values (E3:E50) and I want to list below this column, in
a cell (lets say E52) the SUM of the top 5 highest values.
The glitch (as there always is one) is that I don't want every cell to be
considered - I only want, for example, E5, E8, E11, E14, E17, E20, E23, E26,
E29, E32, E35, E38, E41, E44, E47 & E50 to be included.
Is there a way to do this?
Whilst I mention it - would there be a way, with conditional formatting
perhaps, that any cell in that selection (E5, E8, E11, etc.) that IS a top 5
value - could it become a different colour?
Any help would really be appreciated.
Many thanks,
Cheers
Lee