Pivot table with text

Folks,
In my data set the third column is Explanation where some text can be entered. The first column is a data. Is it possible to show the text that a person entered for any given date on the same line?
Frank FreeseAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
byundtConnect With a Mentor Commented:
You can certainly use a formula outside the PivotTable to return the desired information. And you can record a macro to clear the formula and insert a new one when the PivotTable is refreshed.

In the sample workbook, columns H:J use an array-entered formula what is somewhat slow to recalculate, but which can return a second and third explanation for a given date. Copy the formula to the right if you need to return more possible explanations.
=IFERROR(INDEX(Table1[Explanation],SMALL(IF(Table1[Date]=$F2,ROW(Table1[Date])-ROW(Table1[#Headers]),""),COLUMNS($H2:H2))),"")

Column K uses an INDEX & MATCH formula that is fast, but only returns the first explanation for each date.
=INDEX(Table1[Explanation],MATCH(F2,Table1[Date],0))
PivotTableExplanationsQ28415800.xlsx
0
 
Frank FreeseAuthor Commented:
appreciate it! thank you
0
All Courses

From novice to tech pro — start learning today.