0

I have an Excel table that summarizes data from a TFS query using COUNTIFS() statements. It works great until I get to the end and I want to use a blank value to display a count of the blanks. For the row values I can just type an apostrophe and the value remains blank (row 7 below) but in a header it replaces the apostrophe with 'Column1 (see column E below)...

enter image description here

Before you say, "why don't you use a Pivot Table?" let me answer that I have done just that. The problem lies in the next step wherein I want to display the data in SharePoint which does not seem to recognize Pivot Tables but does recognize regular tables.

Can I do this without VBA?

Sam
  • 487
  • 1
  • 10
  • 25
  • I just created a new column on a structured table using alt+enter (line feed or char(10)) as the column header. Will this suffice? –  Oct 24 '17 at 19:43
  • @Jeeped well, it worked but my "countifs" statement doesn't agree. Alt+Enter left a blank but not a real blank and Char(10) leaves a zero (0). – Sam Oct 24 '17 at 19:58

1 Answers1

0

Incase you still need an answer to this. I have just found that putting a space as the header makes it appear blank.

Thomas
  • 1
  • As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Jul 29 '23 at 12:31