←Back to Beyond Market Intelligence
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Lego excel piece database

Our take

Managing a Lego piece database in Excel can be streamlined while preserving essential information about element IDs. Each piece, identified by a unique element ID, may transition to a new ID over time, complicating tracking. To maintain clarity and ensure easy future searches, consider listing each Lego piece on its own row, accompanied by columns for both old and new element IDs.

Lego pieces each have a unique element id. Lego often replace an old element id with a new one, even though the piece and design id stay the same.

I’m trying to find the best and simplest way to sort these pieces on the same row, but still keep the information of which set has old/new element id to reflect the information originally released in the manual for a set.

Im looking for suggestion on the best way to do this in an excel sheet that I’m working on. I’m considering using notes on the individual cell as my best option, but I’m not sure if that would be best option for future searches. I want pieces on their own row so that it’s easier to quickly see the totals.

submitted by /u/eliseekisaurus
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#rows.com
Lego excel piece database | Beyond Market Intelligence