| Home > Forum Home > Analyzing Corporate Financial Data > Excel - List - Then Easy replace all > Pivot Table for unique rows | Share |
Pivot Table for unique rows
Excel Help for Pivot Table For Unique Rows in Analyzing Corporate Financial Data
| Forum Topic | Login |
Pivot Table For Unique Rows | Rate this: (3/5 from 1 vote) |
 | Since Excel 2008 for Mac doesn't have VBA, the easitest way is to create a Pivot table from the data and put the product as a row field so that it shows a unique list only. This list can then be copied into a new worksheet. To update another column with the same data for each product, you can use a VLOOKUP function that matches the product text. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Pivot Table for unique rows in the Excel Business Solutions Directory |