How to make the formula value in the storage grid into an arithmetic series after copying

%3CLINGO-SUB%20id%3D%22lingo-sub-1574244%22%20slang%3D%22zh-CN%22%3EHow%20to%20make%20the%20formula%20value%20in%20the%20storage%20grid%20into%20an%20arithmetic%20series%20sd%20copying.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574244%22%20slang%3D%22zh-CN%22%3E%3CP%3E%3CSPAN%3EHello%20everyone!%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EAsk%20If%20you%20type%20in%20the%20A1%20storage%20box%20of%20excel%20sheet%201%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ETHE%20.OR%20(COUNTIF%20('WORKSHEET%202'!%20G26%2C%20%22'ok'%22%20COUNTIF%20('Worksheet%202'!%20G26%2C%3C%2FSPAN%3E%3CSPAN%3E%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%20G26%2C%20%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%3C%2FSPAN%3E%3CSPAN%3E%22%2C%22%3C%2FSPAN%3E%3CSPAN%3E%22))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EType%20in%20A2%20storage%20box%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ETHE%20.OR%20(COUNTIF%20('WORKSHEET%202'!%20G36%2C%20%22'ok'%22%20COUNTIF%20('Worksheet%202'!%20G36%2C%3C%2FSPAN%3E%3CSPAN%3E%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%20G36%2C%20%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%3C%2FSPAN%3E%3CSPAN%3E%22%2C%22%3C%2FSPAN%3E%3CSPAN%3E%22))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EType%20in%20the%20storage%20box%20A3%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ETHE%20.OR%20(COUNTIF%20('WORKSHEET%202'!%20G46%2C%20%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%20G46%2C%3C%2FSPAN%3E%3CSPAN%3E%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%20G46%2C%20%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%22%3C%2FSPAN%3E%3CSPAN%3E%22%2C%22%3C%2FSPAN%3E%3CSPAN%3E%22))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThen%20use%20drag%20to%20copy%20to%20A10%2C%20why%20the%20values%20in%20the%20formulas%20of%20A1%20to%20A10%20can't%20set%20g26%2C%20G36%2C%20G46%2C%20G56%2C%20G66%2C%20G76%2C%20G86%2C...%20Arithmetic%20sequence.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EPlease%20help.%20thank!%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1574244%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3ENeed%20Help.%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574489%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20make%20the%20formula%20value%20in%20the%20storage%20grid%20into%20an%20arithmetic%20series%20after%20copying%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574489%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F753162%22%20target%3D%22_blank%22%3E%40Kuang_Yang_Kao%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20formula%20hasn't%20survived%20the%20translation%2C%20but%20try%20changing%20all%20occurrences%20of%20G26%20to%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EINDEX(G%3AG%2C%2010*ROW()%2B16)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello everyone!

Ask If you type in the A1 storage box of excel sheet 1:

=IF(OR(COUNTIF('Worksheet 2'!G26,"*ok*"), COUNTIF('Worksheet 2'!G26,"*Improved*")),"",IF(COUNTIF(' Worksheet 2'!G26,"*"),"",""))

Type in A2 storage box:

=IF(OR(COUNTIF('Worksheet 2'!G36,"*ok*"), COUNTIF('Worksheet 2'!G36,"*Improved*")),"",IF(COUNTIF(' Worksheet 2'!G36,"*"),"",""))

Type in the storage box A3:

=IF(OR(COUNTIF('Worksheet 2'!G46,"*ok*"), COUNTIF('Worksheet 2'!G46,"*Improved*")),"",IF(COUNTIF(' Worksheet 2'!G46,"*"),"",""))

Then use drag to copy to A10, why the values in the formulas of A1~A10 can't become G26, G36, G46, G56, G66, G76, G86,...Arithmetic sequence

Please help. thank!

 

1 Reply

@Kuang_Yang_Kao 

The formula hasn't survived the translation, but try changing all occurrences of G26 to

 

INDEX(G:G, 10*ROW()+16)