Formula to Get Every Nth Cell from a Column in Excel

Excel's Offset function can be used to get every 2nd cell or 3rd from a column.

=OFFSET(A2,(ROW()-1)*2,0)

In this formula A2 is the first cell of A column and 2 (Nth) is the number of cells to skip after that for the next cell to copy.
Paste this formula in desired column and drag down.

Popular posts from this blog

Steps to Turn On Offline Access for Google Docs, Sheets and Slides

Image
You aren't connected to the Internet but still want to work on Google Docs files? Then follow below steps to create, edit or view Google Docs, Sheets and Slides files while you're offline. Connect to the internet. Open or Install Google Chrome browser. Install Google Docs Offline Chrome extension. ( Click Here to Open Install Page ) Open Google Drive Click on Settings Check the box next to "Create, open, and edit your recent Google Docs, Sheets, and Slides files on this device while offline. Done Now you can click on File menu of any Google Docs, Sheets and Slides file and click Make available offline to use that file offline. Alternatively, you can right click on files in Google Drive and then click on Available offline. Watch detailed video on this:
Read more

Formula to Get Country Flags in Google Sheets

Image
I have created a formula to insert country flags in Google Sheets's cells. For this I've used IMAGE, IMPORTXML and SUBSTITUTE functions. In this formula we're taking flag images from Wikipedia.   You can paste below formula in your Google Sheets: =IMAGE("https:"&IMPORTXML("https://en.wikipedia.org/wiki/Gallery_of_sovereign_state_flags","//img/@src[contains(.,'"&SUBSTITUTE(A2," ","_")&"' )]"))  Change A2 with the cell address in which you are typing country name. You need to type first letter of country name in capital letter in order this to work. I have explained this formula in my below YouTube video. You can watch this video to understand how it works:
Read more