1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Lego excel piece database

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]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#row zero
#rows.com
#financial modeling with spreadsheets
#Lego
#pieces
#element id
#old element id
#new element id
#excel sheet
#design id
#set
#row
#sort
#totals
#information