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

@sebastianhebert 

 

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).

=IF(ISBLANK(D2),E1,D2)

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