Behind the Curtain of which function cannot be performed through subtotal in a spreadsheet: Secret Adventures

which function cannot be performed through subtotal in a spreadsheet