title: Alternative of FILTER function on non office 365
body: <p>Using a Macro or Formula, is there a way to achieve the result of the following formula of Office 365?</p>
  <p><code>=FILTER(B:B,A:A = &quot;x&quot;)</code></p>
  <p>What it does is get all the values from <code>Column B</code> if <code>Column A</code> on the same row has a value of <code>x</code>.</p>
  <p>My PC has office 365 but the one I'm working with only has <code>Office Pro Plus 2019</code>. I had to use my pc when I needed the function and I'm getting tired of it, maybe it can be done on Office Pro Plus 2019 too using a formula or a macro?</p>