SOLVED

Start Flag in Excel

New Contributor

Hello All, I am new here and have an issue to solve with Excel. I am trying to get excel to identify when an activity starts based on which i can do calculation. Attached is the file with data and the formula, i thought would work. Please if someone can help me that would be great.

 

Thanks and regards

 

John

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@jelawrence 

 

In G8:

 

=IF(COUNT($G6:G6)=1,1,0)

 

Fill to the right.

Hello Hans. many thanks for this. Very intuitive thinking. Appreciate it

Cheers

John