How to select data from every 4th row?

Copper Contributor

I have a excel database of customers and I need to select the cell with the email address from every 4th row.  How do I do this?  I would then like it to automatically copy and paste into a new excel spreadsheet.  Is this possible?  Thanks  

1 Reply

Hi Karline,

 

You can use this formula in a new Conditional Formatting rule to highlight every 4th row:

=MOD(ROW(),4)=0

 

After that, you can filter these row by color, and copy them into another sheet.

Please find the attached file.

 

Hope that helps