Excel find data - Microsoft Community

support,

i looking formula aid in finding data per row of text.

the scenario,

i have string data in table, table 316789 rows long , contains columns > y.

on every other row example rows 2,4,6,7,9,10....etc 1 of cells contain string “(hitcnt=12321)”.

please note number on each row after “hitcnt” maybe different.

what need formula first check row 1, , if finds cell between a1 > y1 contains string “hitcnt”, copies entire cell z1.

the formula move onto next row , same thing.

the main problem in 316789 rows of data, th string “hitcnt” in cell.

if worked on every cell individually work using formula =if(isnumber(search(“hitcnt”,n1)),n1,””)

but formula dependant on me knowing in every row string hitcnt in column n, might not case.

is possible that?

the trick use match function index

so snip readable used m

best wishes

Office / Excel / Microsoft Office Programming / Office 2016

Cororate