Excel Loop Formula (Change cells based on result of another cell)
Hello,
Seeking assistance on a formula that sums column D per ID (column B). If the result is more than 0 it should read 'True' in the result column (E). Here is the catch....I also need column D to show as 'True' for all other matching IDs. So in the attached example, you see there is a 1 in cell D5. Since the sum for ID 65656 is greater than 0, all rows that have ID 65656 have a 'True' in column E.