Forum Discussion
Keep the row numbers in pivot table when you sort on field
kennethsorsdalbirno right. This way it is never going to work. Excel doesn't "know" the data you put next to a pivot table needs to stay with a certain row of the pivot table. You need to create a separate table for the comments which has all the unique items which are your current pivot table rows. Then use a lookup formula to fetch the information from that table next to your pivot table.
The first picture you see the table when i have not used the filter. You can see the comments at each row.
In this picture i have used the filter 100. You can see that the comments do not follow the row they where written to
kennethsorsdalbirno right. This way it is never going to work. Excel doesn't "know" the data you put next to a pivot table needs to stay with a certain row of the pivot table. You need to create a separate table for the comments which has all the unique items which are your current pivot table rows. Then use a lookup formula to fetch the information from that table next to your pivot table.