No Headers in my table

[DrandonC]

This is strange. Beginning the middle of last week when I convert my data from a range to a table, checked the box that includes Headers, the "refers to" begins in Row 2, eliminating my Headers.
When I go to Formulas, Named Ranges, "refers to" begins A2 and it is greyed out. My sheet is unprotected. In Table Design > Resize Table > it begins with A1 and the Header Box is checked.
If I create a new sheet and type "=Table1" it gives me all my data without Headers. I work for a large organization where AIT is pretty baffled. It's also affecting my coworkers. AIT has updated Drivers and Windows updates, and even has tried an Office Repair. No effect. I would like to use GroupBy but Headers I need. Anyone out there have any ideas? This is such a pain.
Thanks in advance.

 

[Fluff]

What your saying sound perfectly normal for a Table. If you want to include the header row you need to use

=Table1[#All]

 

[Alex Blakenburg]

And for a column
without the headers

=Table1[Col2]

With the headers

=Table1[[#All],[Col2]]

When typing the formula:
• For the whole table hover the mouse over the top left corner border until you get an arrow that point diagonally to the table.
Click once for the Table without the header, click twice if you want to include the header.
• For a column hover the mouse over the top border of the column until you get an arrow.
Click once for the Column without the header, click twice if you want to include the header

 

[DrandonC]

I am still unable to utilize the GroupBy formula..

 

[Fluff]

In what way?

 

[DrandonC]

In what way?

using Groupby I cannot pull in Headers, the display Headers argument pulls in the first row of data thinking that that row is the Headers. All since my table "refers to" starts at row 2. Headers being in row 1.

 

[Fluff]

since my table "refers to" starts at row 2

That is the way it has always been & makes no difference. Both Alex & myself have shown how to include the headers.
What is the formula you are trying to use? & can you post some sample data showing the problem.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[DrandonC]

I work for a large Healthcare system and cannot share data. This may help. I am not pulling back Headers instead, I pull back the first row of data.

 

[Fluff]

That's because you have done it like Alex showed in post#3

 

[Alex Blakenburg]

As Fluff mentioned if you follow the steps in Post #3 using the mouse you should finish up with this:

=GROUPBY(Table1[[#All],[CDM]],Table1[[#All],[Amt/Qty]],SUM,3)

If you need a visual of the process, Debra Dalgleish's youtube video below. It is on the sister function PivotBy but the process is identical.
She is very clear that she wants the headings included and gives very clear instructions.
You only need to watch the first 2 mins and can even start at the 50 sec mark if you really want to zoom in.