(Solved) – Returning cell value if greater than 0

(solved)-–-returning-cell-value-if-greater-than-0

Using nested formulas or VBA, I want to return ratings that are greater than 0 in each rating column for all individuals. The results for each column should be right below the last filled row as shown below:
Spreadsheet before calculations:

     Rating A     Ratings B     Ratings C
Jane    0           -1              0
Rick    1           -2              1
Johnny -1            2              5
James   3            2              3

After:

       Rating A        Ratings B         Ratings C
Jane     0                -1                0
Rick     1                -2                1
Johnny  -1                 2                5 
James    3                 2                3
        Rick            Johnny          Johnny
         1                 2                5
        James            James            James
         3                 2                3
                                          Rick
                                            1

As seen above, Rick and James have Ratings A >0 so the formula outputs the results beginning in the next empty row on Rating A Column. Same technique for Ratings B and C. Please note that this is a much smaller exempt of a larger spreadsheet. I can’t post the full spreadsheet that’s thousands of rows and columns.

Leave a Reply

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