I have the following table:
John 8
Jean 7
Jane 100
Jean 9
Jeff 4
John 100
Jean 8
John 7
Jane 5
If I filter the above table on John, I will have
John 8
John 100
John 7
The function =SUBTOTAL(4,B2:B10) will give the value 100. However I would want the SUBTOTAL function to ignore the particular value 100, so that =SUBTOTAL(4,B2:B10) will give 8 in the above case.
How would I achieve this? Thanks in advance.
Bookmarks