snipt

Ctrl+h for KB shortcuts
Sign up for : store and share your own code snippets.
#137559

Text only

Google Sheets Inline Array in formula

1
2
3
4
5
6
7
8
Use curly brackets with each value separated by commas.

{4,18,22,9,2,4,99,43}

{C2,D2,E2,F2,G2,H2,J2,K2,L2,M2,N2,O2}

Example of using in formula.
=SPARKLINE({C2,D2,E2,F2,G2,H2,J2,K2,L2,M2,N2,O2})
https://snipt.net/embed/644d801a8ab6260b150f20ee96e35cc5/
https://snipt.net/raw/644d801a8ab6260b150f20ee96e35cc5/
644d801a8ab6260b150f20ee96e35cc5
text
Text only
8
2015-04-20T11:14:09
True
False
Dec 08, 2014 at 05:16 PM
/api/public/snipt/137559/
google-sheets-inline-array-in-formula-b86cfa5c
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a> <a href="#L-5">5</a> <a href="#L-6">6</a> <a href="#L-7">7</a> <a href="#L-8">8</a></pre></div></td><td class="code"><div class="highlight"><pre><span id="L-1"><a name="L-1"></a>Use curly brackets with each value separated by commas. </span><span id="L-2"><a name="L-2"></a> </span><span id="L-3"><a name="L-3"></a>{4,18,22,9,2,4,99,43} </span><span id="L-4"><a name="L-4"></a> </span><span id="L-5"><a name="L-5"></a>{C2,D2,E2,F2,G2,H2,J2,K2,L2,M2,N2,O2} </span><span id="L-6"><a name="L-6"></a> </span><span id="L-7"><a name="L-7"></a>Example of using in formula. </span><span id="L-8"><a name="L-8"></a>=SPARKLINE({C2,D2,E2,F2,G2,H2,J2,K2,L2,M2,N2,O2}) </span></pre></div> </td></tr></table>
"google sheets", array, google, sheets
Copyrighted, illegal, or inappropriate content? Email nick@snipt.net.