I have a spreadsheet that lists a number of items, the second columns says if it will be Sold or Purchased and then the third column has a value. I would like to create a list that takes all the "Sell" from the list above and lists them with the value in the column next to the name. I am fairly sure I should use an Array and Match but unsure how to do it.
<tbody>
</tbody>
I want a table to dynamically generate the listing of the buy info
<tbody>
</tbody>
Any help is greatly appreciated.
GG
Name | Action | Value |
a | Buy | 10 |
B | 66 | |
C | Sell | 33 |
D | Buy | 4 |
<tbody>
</tbody>
I want a table to dynamically generate the listing of the buy info
Buy | A | 10 | ||
Buy | D | 4 | ||
<tbody>
</tbody>
Any help is greatly appreciated.
GG