Formula Help

Occasional Visitor

Working on a spreadsheet, trying to pull information from one tab to another. I have a bunch of raw data with part #'s as headings in column D, and the rest of the column is empty until the next part # heading. I want a formula that will recognize each line of data based on which part # it is under, there are 140,000 lines of data so this will speed up the process

1 Reply



Here's an easier (I think) solution. Add a column (E perhaps), what we often call a "helper column" and populate each row with the part number using this formula, copied down. (This is assuming that D2 contains your first part number).


That will populate the row with the applicable part number and make looking things up a lot easier.