SOLVED

Start Flag in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2359937%22%20slang%3D%22en-US%22%3EStart%20Flag%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2359937%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%20I%20am%20new%20here%20and%20have%20an%20issue%20to%20solve%20with%20Excel.%20I%20am%20trying%20to%20get%20excel%20to%20identify%20when%20an%20activity%20starts%20based%20on%20which%20i%20can%20do%20calculation.%20Attached%20is%20the%20file%20with%20data%20and%20the%20formula%2C%20i%20thought%20would%20work.%20Please%20if%20someone%20can%20help%20me%20that%20would%20be%20great.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20and%20regards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2359937%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2360079%22%20slang%3D%22en-US%22%3ERe%3A%20Start%20Flag%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2360079%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1055470%22%20target%3D%22_blank%22%3E%40jelawrence%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20G8%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(COUNT(%24G6%3AG6)%3D1%2C1%2C0)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20to%20the%20right.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2360622%22%20slang%3D%22en-US%22%3ERe%3A%20Start%20Flag%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2360622%22%20slang%3D%22en-US%22%3EHello%20Hans.%20many%20thanks%20for%20this.%20Very%20intuitive%20thinking.%20Appreciate%20it%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3CBR%20%2F%3E%3CBR%20%2F%3EJohn%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
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