Help me code VBA for google sheet!

[Nguyen Anh Dung]

link google sheet test:

Google Sheets - create and edit spreadsheets online, for free.

Create a new spreadsheet and edit with others at the same time -- from your computer, phone or tablet. Get stuff done with or without an internet connection. Use Sheets to edit Excel files. Free from Google.

docs.google.com

 

[RoryA]

Google sheets doesn’t use or support VBA, I’m afraid. I suspect from your pictures you can get what you want using formulas though.

 

[Nguyen Anh Dung]

Google sheets doesn’t use or support VBA, I’m afraid. I suspect from your pictures you can get what you want using formulas though.

you can help me formulas?

 

[RoryA]

Your document is not set up for public access, so I can't see it.

 

[Nguyen Anh Dung]

Your document is not set up for public access, so I can't see it.

yes, sorry! i have edit share public access.

Test

docs.google.com

Thanks you!!!

 

[RoryA]

You can just use:

=join(",",unique(A!B2:B11))
=join(",",unique(B!B2:B11))

 

[Nguyen Anh Dung]

T

You can just use:

=join(",",unique(A!B2:B11))
=join(",",unique(B!B2:B11))

thanks you so much!!!

 

[Nguyen Anh Dung]

T
thanks you so much!!!

I use the reference function with a ","