Avatar of Escanaba
Escanaba
Flag for United States of America

asked on 

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.

Thanks!
EE-Example.xlsx
Microsoft OfficeSpreadsheetsMicrosoft ExcelMicrosoft Applications

Avatar of undefined
Last Comment
Escanaba

8/22/2022 - Mon