@VinayKumarModi-x1c
use subtotal instead of sum, still you can use filter :)
@UsmanAfzal-h1s
Kenji you rock bro
@rangarajanbalakrishnan9529
how to deal with comma separated values [100+] like a,b,c and x,y,z in second row. I want a,b,c,x,y,z values in six rows one letter in each row. This is without using power query
@suddu_shetty
Let's say I'm using the filter function only, but I need the total below every selection. The data will not be the same, and I need to move the sum function every time I change any options. Right now i have total cell above heading any other option
@Varman108