Data Analysis

I need the formula in Col E to look at Columns A-D for any number/amount, and if there is, then copy what’s in the header of that particular column.

 

  Col A Col B Col C Col D Col E Col F
Row 2 Apple Orange Banana Pear Product Amount
Row 3 1       Apple 1
Row 4   1     Orange 1
Row 5     2   Banana 2
Row 6       1 Pear 1
Row 7 1       Apple 1
Row 8 2       Apple 2
Row 9     3   Banana 3
Row 10   4     Orange 4

By: Karen

One thought on “Data Analysis

  1. Karen

    Actually, I’d like to expand the formulas to capture if more than one product is bought (see spreadsheet)

    Col A Col B Col C Col D Col E Col F Col G Col H
    Row 2 Apple Orange Banana Pear Product#1 Amount Product#2 Amount
    Row 3 1 Apple 1
    Row 4 1 Orange 1
    Row 5 2 Banana 2
    Row 6 1 Pear 1
    Row 7 1 Apple 1
    Row 8 2 Apple 2
    Row 9 3 Banana 3
    Row 10 4 2 Orange 4 Pear 2

Leave a Reply

Your email address will not be published. Required fields are marked *