Check count text by row

I would like to check count text by row (columnA)
If in column A in each row count text = 4 alert row.

Please guide me.

inside foreach loop use if condition
convert.toInt32(row(“Count Text”))=4
then you can use your alert message

Hope it will work

image

If each row count text = 4
get data next row until found text “Net” in row

you want to get the data on basis of “Net” value right?
You can do it in this way like add if condition inside foreach that row(“Detail”).toString.equal(“Net”) then do nothing else get the remaining values.

What is the purpose of row count text? what is it?