0
I have a few Pivot Table questions concerning the ability to sort/filter but hide the values used to do so.
Post Flair (click to view more posts with a particular flair)
Post Body
Excel 10
I have a table that consists of an item, and an associated ratio. I'm filtering by a range of values, so as only to show a select few (oh my god that's so awesome). Is there a way I can output just the item names while hiding the values that I used to filter with? The ratio is a number that wouldn't make sense to my clients but the result of a formula I made to rank various traits. I just want to output the names of the items which fit that criteria.
EDIT: For now it's white text/white background...
Can I do conditional formatting within the pivot table?
Author
u/cedargrove
Strong
18 years old · 51k karma
Account strength
100%
Age
18 years
Total karma
51k
Comment karma
49k
Signals
Verified email
Verified flair
Profile refreshed 1 year ago
Posts refreshed 1 year ago
Subreddit
Post Details
We try to extract some basic information from the post title. This is not
always successful or accurate, please use your best judgement and compare
these values to the post title and body for confirmation.
- Posted
- 12 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...