Would you like to learn more about Excel Please consider supporting me by buying me a coffee (it takes a lot of coffee to write these articles).

But this is still cumbersome especially if you want to have and additional filter going forward.

The data rows used for the pivot table should have exactly one row with a 1 for each section of rows.

Im using the German version and Excel wants to have semicolons.

BTW: I translated the function names to the english ones to be international but forgot about the divider.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged excel excel-formula pivot-table distinct powerpivot or ask your own question.

The following sections provide examples of how to create a custom list in Excel Preferences and from a series of cells.

If you have just one Return key that says Enter as well, press this key.

A dotted line indicates the selected cell range, and Excel automatically types the selected range into Custom Lists preferences pane.

The Import List from Cells pop-up menu displays the range you selected.

Enable Solvertable In Excel Professional Presentations And

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

How To Enable Solvertable In Excel For Mac