google analytics - EXCEL Filter Columns - Containing Numbers Greater Than X -
so here's example of data in 1 of columns /festivals/upcoming /win/competitions/572 /latest/reviews/14940 --- 1 shown /latest/news/15521 /download-festival-2014/lineup is possible filter column 3rd 1 down (as commented) shown. need take last string after last forward slash, check if it's number, if number , if it's less 14650, keep it i exported excel google analytics if it's easier there, good! thanks if data in a1 this, , drag down: =if(iferror(value(trim(clean(trim(left(right(substitute($a1,"/",rept(" ",99)),(2-column(a1))*99),99))))),"")>14650,iferror(value(trim(clean(trim(left(right(substitute($a1,"/",rept(" ",99)),(2-column(a1))*99),99))))),""),"")