John Whyte Posted August 14, 2014 Share Posted August 14, 2014 Ive crated a report that counts the number of instances of certain symbols in my file. At the moment ive got two columns 'symbol name' column A and 'instance count' column B, is it possible to get an instance of the symbol so it can be used as a key (although i wouldn't want the symbol instance in the key counted as part of the report) Quote Link to comment
Macluskie Posted August 14, 2014 Share Posted August 14, 2014 Just tried it and it doesn't count the symbol in the worksheet Function is "Image" Criteria is (for me) Symbol > Contains > (then use wee select symbol tool and you'll see a preview) OK that and add your equals sign and it will display the symbol image in your worksheet Hope that helps :-) Worksheet Example Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.