Amount of Posts on Hashtag Instagram

Posted by on Jun 18, 2017 in Uncategorized | No Comments

Get amount of posts under certain hashtag on Instagram: =value(substitute(if(iserror(search(“.”,REGEXEXTRACT(IMPORTXML(A1,”//meta[@name=’description’]/@content”),”[\d]{1,}[\D]{0,1}[\d]{0,3}.{0,1}\s”))),substitute(substitute(REGEXEXTRACT(IMPORTXML(A1,”//meta[@name=’description’]/@content”),”[\d]{1,}[\D]{0,1}[\d]{0,3}.{0,1}\s”),”k”,”000″),”m”,”000000″),substitute(substitute(REGEXEXTRACT(IMPORTXML(A1,”//meta[@name=’description’]/@content”),”[\d]{1,}[\D]{0,1}[\d]{0,3}.{0,1}\s”),”k”,”00″),”m”,”00000″)),”.”,””)) Formula by Ben Collins, found in this post