Home

How to select data from every 4th row?

Karline
Occasional Visitor

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies