Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 11 years, 9 months ago. Active 10 years, 2 months ago. Viewed k times. Community Bot 1 1 1 silver badge.
Peter Craig Peter Craig 6, 17 17 gold badges 57 57 silver badges 73 73 bronze badges. Here is a way to return true empty blank as a formula result: stackoverflow. Add a comment. Active Oldest Votes. I'm generating a graph from the data and so "" is graphed as 0 yet a NULL cell isn't graphed. PeterCraig You can return NA which won't be graphed. Once the formula is applied, we will get the sales value for Peter in February month which is In cell B6, to get the sales value of Peter which is for both the months.
The space between the two named ranges is the Intersect Operator. You can also go through our other suggested articles —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.
Popular Course in this category. If you are a Microsoft subscriber, make sure you have the latest version of Office. In order to maintain backwards compatibility with other versions of Excel, this feature is off by default. Click the Show data in hidden rows and columns option if you want Excel to plot hidden data. You can always ask an expert in the Excel Tech Community , get support in the Answers community , or suggest a new feature or improvement.
We're listening. Create a chart from start to finish. Notes: This feature is only available if you have a Microsoft subscription and is currently only available to Insiders. Need more help? Expand your skills. Get new features first. Was this information helpful?
0コメント