Forum Discussion
How to select data from every 4th row?
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
