Excel - Query

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 !!

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

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

Have you tried using RowIndex?

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

My input:

image

Output:

image

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

2 Likes