SOLVED

Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-2019244%22%20slang%3D%22en-US%22%3EFormula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2019244%22%20slang%3D%22en-US%22%3E%3CP%3EI%20cannot%20get%20a%20formula%20to%20work%20with%20this%20excel%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2019244%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2019291%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2019291%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F899904%22%20target%3D%22_blank%22%3E%40mehoop%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChange%20the%20formula%20in%20G2%20to%3C%2FP%3E%0A%3CP%3E%3D--LEFT(F2%2C5)%3C%2FP%3E%0A%3CP%3Eand%20fill%20down%20to%20G302.%3C%2FP%3E%0A%3CP%3EChange%20the%20formula%20in%20J2%20to%3C%2FP%3E%0A%3CP%3E%3DCOUNTIFS(%24G%242%3A%24G%24302%2C%22%26gt%3B%3D%22%26amp%3BH2%2C%24G%242%3A%24G%24302%2C%22%26lt%3B%22%26amp%3BI2)%3C%2FP%3E%0A%3CP%3Eand%20fill%20down%20to%20J4.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I cannot get a formula to work with this excel file

2 Replies
best response confirmed by mehoop (New Contributor)
Solution

@mehoop 

Change the formula in G2 to

=--LEFT(F2,5)

and fill down to G302.

Change the formula in J2 to

=COUNTIFS($G$2:$G$302,">="&H2,$G$2:$G$302,"<"&I2)

and fill down to J4.

Hans, THANK YOU very much, it worked like I want it to