Listing Codes from a Particular Vendor in Excel

Asked

Viewed 78 times

0

I have a Product Table with Code and Supplier.

I would like to know how can in the vendor table list all the codes from a specific vendor.

I can do this only through formulas in Excel?

Example below:

inserir a descrição da imagem aqui

1 answer

2


Boas @lukkicode,

see if this solution fits what you want.

Table Dynamics

inserir a descrição da imagem aqui

inserir a descrição da imagem aqui

  • Very good. I didn’t know there was such an option. But can you do it horizontally and by formula? (I will enter more supplier details later)

  • Through formula, I’m not getting the result you want, but someone might. Even if you enter more supplier data just update the data source.

  • I’ll use it the way you said. Thanks R.Galamba.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.