=INDEX(IF(
VLOOKUP(C6:AG6;{D3:D4\F3:F4};2)>=C6:AG6;
VLOOKUP(C6:AG6;{D3:D4\C3:C4};2);
))
=toMD5(B2)
B2
или где там у вас строка, для которой надо посчитать хеш. const mode = chart.modify()
.asPieChart()
.asPieChart()
.setTransposeRowsAndColumns(false)
.setNumHeaders(1)
.setOption('bubble.stroke', '#000000')
.setOption('annotations.domain.textStyle.color', '#808080')
.setOption('textStyle.color', '#000000')
.setOption('legend.textStyle.color', '#191919')
.setOption('pieSliceTextStyle.color', '#000000')
.setOption('titleTextStyle.color', '#757575')
.setOption('annotations.total.textStyle.color', '#808080')
.build();
function run() {
const sheet = SpreadsheetApp.getActiveSheet();
const base = sheet.getRange('I3:I');
const colFormula = sheet.getRange('J3');
draggDownFormulas_(base, colFormula);
const colFormula2 = sheet.getRange('K3');
draggDownFormulas_(base, colFormula2);
}
function runBulk() {
const formulasCells = ['J3', 'K3', 'M3'];
const sheet = SpreadsheetApp.getActiveSheet();
const base = sheet.getRange('I3:I');
formulasCells.forEach((cell) => {
const colFormula = sheet.getRange(cell);
draggDownFormulas_(base, colFormula);
});
}
fields: "id,name,webViewLink"
).=IMPORTXML(
"http://www.cbr.ru/scripts/XML_daily.asp?date_req="&TEXT(TODAY();"dd.MM.yyyy");
"//ValCurs/Valute[CharCode=""UAH""]/Value"
)/10
=IMPORTXML(
"http://www.cbr.ru/scripts/XML_daily.asp?date_req="&TEXT(C1;"dd.MM.yyyy");
"//ValCurs/Valute[CharCode=""UAH""]/Value"
)/10
VLOOKUP
, например,=INDEX(IFERROR(VLOOKUP(A1:A8;D1:E4;2;0)))
QUERY(;;0)
C2
к нужному формату =date '"&TEXT(C2;"yyyy-MM-dd")&"'
=IFNA(
QUERY(
'Sales Data'!A:Q;
"Select P where (F=0 and A="&A2&" and O=date '"&TEXT(C2;"yyyy-MM-dd")&"')";
0
);
)
.*?shipid:([^\/]+).*?mmsi:([^\/]+).*?imo:([^\/]+).*?vessel:([^\/]+).*?
www.myshiptracking.com/vessels/$4-mmsi-$2-imo-$3
www.marinetraffic.com/ru/ais/details/ships/shipid:4643053/mmsi:477636800/imo:9751327/vessel:NING_JING_HAI/
www.myshiptracking.com/vessels/NING-JING-HAI-mmsi-477636800-imo-9751327
=REGEXREPLACE(B9,B3,D3)
_
", тогда как нужно тире "-
".