Hi All
I am trying to AVE MIN and MAX values in a column based on what appears in another column.
The coding below is what I'm using but it either shows false or gives the answer but is outside the criteria. i.e. it's the column AVE MIN MAX rather than the criteria AVE MAX MIN.
Can anyone help
Thanks in advance
nld
![]()
{=IF('Current Bonds'!$E$13:$E$490>"",MIN('Current Bonds'!$G$13:$G$490))}
Bookmarks