google sheetsgoogle-apps-script
There's a cell that would contain the number of times a letter would be printed in a cell.
i.e.
cell a1 = 3. b1 should look as "A A A"
my rough script is:
for(var arow=0; arow<4; arow++) {
var numberofo = actsheet.getRange(arow+1,1).getValue();
for(i=0; i<=numberofo;i++) {
var test = actsheet.getRange(i+1,2).setValue("o");
};
}
Sorry the code looks rough. Haven't coded for the last 7 years.
I would go about solving it a bit differently. Advantage is that this little code will prepare the table at once.
function tournament(range) {
// create output array
var output = [];
// add header names
output.push(["Name", "Number"]);
// create table
for(var i=2, iLen=range.length; i<iLen; i++) {
for(var j=0, jLen=range[0].length; j<jLen; j++) {
// push letter, ring number * 100 + tournament into array
output.push([range[i][j], (range[0][j] * 100) + (i-1)]);
}
}
// return table
return output;
}
data
result
I've created an example file for you: Tournament
You're looking for the IF command, combined with NE (not equal):
IF(NE(RedCellReference,"No"), LeftCellReference, "")
Best Answer
Is this a scripting challenge for yourself? Or are you actually trying to solve a real-world problem. If the latter, you don't need script, just a formula:
=REPT("A",A1)