•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Creating Master List from Master BOM
This is a simplified version of what working on. I am trying to create a formula that test if a cell has value (in an array, E137:L153) and returns the related description cell in the same row. So I am trying to make a Master list (below of image) from the information in the Master BOM (top). Specifically I am not sure how to get it to skip rows that have no value (or 0) and move on to the next cell under (If no cells under, then the test moves on to the top row of the next column).
I've used a combination of setting variables and indexing arrays, but I can't figure it out.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#row zero
#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#formula generator
#Excel alternatives
#Master List
#Master BOM
#formula
#cell
#description cell
#array
#values
#indexing arrays
#rows
#skip
#variables
#next column
#cells under