I am having the same issue as well. I would like to use arrow icons to indicate where values have gone from one month to the next. For example is the value went from 1 --> 1.5 I'd like to show and arrow pointing up. Because the reference is absolute, it will only work cell by cell and not...
Thanks for the quick response! Just tried the helper column option and it worked great! For the other option where are you supposed to "Right click> value filters"? The helper column is awesome but want to see about a way to manipulate on the fly as well?
Thanks again!
When filtering data within a Pivot Table is there a way to quickly select multiple filter items without having to click or use the arrow keys/space bar?
I look at a lot of information with incremental ranges and want to, for example, look at everything above, below or between certain data...
Hi All,
I have been following the email newsletter for quite some time and enjoy visiting the blog site for additional tips and to search for answers. The sites are great and a valuable resource for anyone who uses Excel.
Drew