<p>Some of the important Excel formulas and commands are as follows:</p>
<h3 id="heading-column-to-comma-separated-values">Column to comma-separated values</h3>
<pre><code class="lang-plaintext">=TEXTJOIN(",", TRUE, A:A)
</code></pre>
<h3 id="heading-select-entire-column">Select entire column</h3>
<pre><code class="lang-plaintext">Ctrl + Space
</code></pre>
<h3 id="heading-look-for-value-from-a-column-in-table-or-list">Look for value from a column in table or list</h3>
<pre><code class="lang-plaintext">=VLOOKUP($A1, list2, 2, false)
=VLOOKUP(A2, G:G, 1, 0)
=VLOOKUP(A2, J:K, 1, 0)
</code></pre>
<h3 id="heading-conditional-if">Conditional IF</h3>
<pre><code class="lang-plaintext">=IF(A2&lt;&gt;A1,"LAST","")
=IF(E2="Override", $B2,"")
</code></pre>
<h3 id="heading-return-count-of-cells-equal-to-a-specific-value">Return count of cells equal to a specific value</h3>
<pre><code class="lang-plaintext">=COUNTIF(range, value)
=COUNTIF(A3:A12, "blue")
</code></pre>
<h3 id="heading-sum-of-values-in-column">Sum of values in column</h3>
<pre><code class="lang-plaintext">SUM(A:A)
</code></pre>
<h3 id="heading-count-unique-values">Count unique values</h3>
<pre><code class="lang-plaintext">=COUNTA(UNIQUE(A1:A12))
</code></pre>


Some of the important Excel formulas and commands are as follows:

### Column to comma-separated values

```plaintext
=TEXTJOIN(",", TRUE, A:A)
```

### Select entire column

```plaintext
Ctrl + Space
```

### Look for value from a column in table or list

```plaintext
=VLOOKUP($A1, list2, 2, false)
=VLOOKUP(A2, G:G, 1, 0)
=VLOOKUP(A2, J:K, 1, 0)
```

### Conditional IF

```plaintext
=IF(A2<>A1,"LAST","")
=IF(E2="Override", $B2,"")
```

### Return count of cells equal to a specific value

```plaintext
=COUNTIF(range, value)
=COUNTIF(A3:A12, "blue")
```

### Sum of values in column

```plaintext
SUM(A:A)
```

### Count unique values

```plaintext
=COUNTA(UNIQUE(A1:A12))
```

Important and must know excel commands and formulas for daily use.

Must Know Excel commands and formulas for daily use

Cheatsheet

Important Excel Formulas and Commands we need to know

Code Buzz - Coding Solutions, Low-Level and High-Level Design, Cheat sheet, Commands, GitHub, Hash node, Portfolio and Projects. Quick reference for development of Java and React.