Excel - Query

Rakesh_Sampath · February 23, 2021, 3:04am

Hello people!!

How can i loop through only even rows of a column. If there is any way please let me know!!

Thanks in advance !!

prasath17 · February 23, 2021, 3:20am

@Rakesh_Sampath …could you please explain your query with example?

Rakesh_Sampath · February 23, 2021, 3:31am

Hi @prasath17
I have a excel column named Phone number, I need to loop through that column to get the data but only the even row’s data i.e, 2nd row’s 4th row’s etc.

Thanks

monsieurrahul · February 23, 2021, 3:39am

Have you tried using RowIndex?

prasath17 · February 23, 2021, 3:54am

@Rakesh_Sampath - There may be better way…this is one i just thought…

My input:

Output:

You can see, it is reading only 2, 4 6, 8 and 10…