jeudi 28 février 2019

SUM of multiple columns text in Excel

Is the first time writing a command in excel so I have no particular idea what I'm doing.

As you can see from the image I'm trying to get in the "All Stores" column all the Stores that have the "X" in them.

At the moment the command that I'm using is displaying the output of the first cell where it finds an "X".

In this particular example the expected result would be "Store1, Store3".

Thank you for your support!

Product Store Example

Aucun commentaire:

Enregistrer un commentaire