Trouble retrieving numbers using IMPORTXML-CodePudding

does anyone know how to grab the # of networks (as marked out below) in a list on this

CodePudding user response：

try:

=QUERY(IMPORTXML(A1, "//div[@class='scrollable']/div"), 
 "select Col3 where Col3 is not null")

CodePudding user response：

Try

=importxml(A1,"//div[@class='scrollable']//div[@class='participants']")

You can get all data at once by

=importxml(A1,"//div[@class='scrollable']//div[@class='exchange']|//div[@class='scrollable']//div[@class='name']|//div[@class='scrollable']//div[@class='participants']")