Copy cell from every nth row

google-sheets google-sheets-formula
tim peterson picture tim peterson · Aug 1, 2015 · Viewed 17.5k times · Source

I'd like to grab the names in every person's name from this google spreadsheet and put it into a new column. The names will be every nth row.

get every nth row in google spreadsheet

Answer

JPV picture JPV · Aug 1, 2015

Alternatively, also try:

=filter(A2:A, mod(row(A2:A)+1,3)=0)

Related questions

Conditional formatting based on another cell's value

I'm using Google Sheets for a daily dashboard. What I need is to change the background color of cell B5 based on the value of another cell - C5. If C5 is greater than 80% then the background color is green …

Read More
Count cells that contain any text

I want to count the cells that contain anything within a range. Any cell that contain text, or numbers or something else should do a plus one in my result-cell. I found this function, countif(range; criteria) but this doesn't …

Read More
Get the last non-empty cell in a column in Google Sheets

I use the following function =DAYS360(A2, A35) to calculate the difference between two dates in my column. However, the column is ever expanding and I currently have to manually change 'A35' as I update my spreadsheet. Is there …

Read More