What I am trying to do is make this formula =iferror(if(match($A2&F$1,arrayformula(Transpose!B$3:B&Transpose!B$1),0),"P"),"") into a script for google sheets. Essentially the formula run in every other column after F and every row under 2 . For example in Column H I have =iferror(if(match($A2&H$1,arrayformula(Transpose!C$3:C&Transpose!C$1),0),"P"),"") in Column J I have =iferror(if(match($A2&J$1,arrayformula(Transpose!D$3:D&Transpose!D$1),0),"P"),"") and so on. The way I have it right now has this formula pasted in every cell of every other column and as I add more data I have to adjust the formula so it takes too long. I have attached the Workbook so you can see what I am talking about. Any help would be appreciated. Thank you
https://docs.google.com/spreadsheets/d/1ZBrg4XoeL21mXwn93XT35kgjrE5pqx9cd3xEvfojIXM/edit?usp=sharing
Aucun commentaire:
Enregistrer un commentaire