Learn Excel Episode 738: Unique SN per CN

Posted in Companies, Podcasts on July 15, 2008



Matthew sends in a cool technique today to find a unique list of serial numbers for every model from a database. Matthew's trick uses about five tricks that you probably rarely use. Episode 738 walks you through Matthew's technique. You will see pivot table calculated fields, paste values, replace, and deleting all zero cells.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Pivot Table