vendredi 8 novembre 2019

A custom function for joining cells and an optional value from an adjacent cell in Google spreadsheets?

I have a sheet that looks like this:

    --------------------------------------------------------------------------------
    Item     |   Count   |
    -----------------------------------------------------------------------------------
    Milk     |     1     |
    -----------------------------------------------------------------------------------
    Cereal   |     3     |
    -------------------------------------------------------------------------------
   Bread     |     2      |

When I use the JOIN function, I would get something like Milk, Cereal, Bread. What I want to do is add the value from the count column, but only if the value is greater than 1. So a custom function would print something like Milk, Cereal x3, Bread x2 How could I achieve this in Google Spreadsheets?

Aucun commentaire:

Enregistrer un commentaire