R
Ryan W.
While working on a sales rep sheet I noticed that when you filter a table in
your chart some of your functions are not recognized even though you’re still
referring to the same cells. I don’t know why this happens and am hoping for
some help.
I’ve provided two screenshots below. The first one shows what happens when I
sort the Grade Table from Z -> A, and the second shows what happens when
sorted A -> Z. The latter works perfectly, but I’m just curious as to why the
other does not?
http://img148.imageshack.us/img148/2575/filter1w.jpg
http://img638.imageshack.us/img638/2818/filter2.jpg
your chart some of your functions are not recognized even though you’re still
referring to the same cells. I don’t know why this happens and am hoping for
some help.
I’ve provided two screenshots below. The first one shows what happens when I
sort the Grade Table from Z -> A, and the second shows what happens when
sorted A -> Z. The latter works perfectly, but I’m just curious as to why the
other does not?
http://img148.imageshack.us/img148/2575/filter1w.jpg
http://img638.imageshack.us/img638/2818/filter2.jpg