Aug 07 2020 08:23 PM
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!
Aug 08 2020 01:52 AM
The formula hasn't survived the translation, but try changing all occurrences of G26 to
INDEX(G:G, 10*ROW()+16)