Hello Excel chiefs,
I have this problem with Excel 2010. I'm hoping you might help me out.
I'm building an inventory database for metals.
I'm trying to make an overview of all our metals, or what's left of them after cutting.
Unfortunately, the pivot table I've made doesn't show duplicate entries. Lots of them are duplicate however (e.g. 650).
Any ideas to reveal those darned duplicates, or maybe an alternative for showing all diameters with their corresponding lengths as in the picture?
*lengte = length, over = what's left after cutting (yeah, I'm Dutch).
Thanks!
Edit: I figured it out. Well, not entirely but I put an extra column in that states how many times a specific entry does show up.
Thanks for considering my request!
http://postimg.org/image/qvf2ci58t/
Bookmarks