save every fifth cell in column to an other column

Forums: Excel
Email this Topic • Print this Page

I have a very lengthy column of data in Excel (5 Hz; i.e. five entries per second of test time) and I want to save one in five cells to shorten the dataset (i.e. one entry per second). Is there an easy way to do this?

Topic Stats
Top Replies
Link to this Topic

Type: Question • Score: 0 • Views: 838 • Replies: 1

[+3] - engineer - 09/10/2014If you data is in column A, put the following formula in cell B1 (or whatever cell is next to your data: = mod(row(b1)) Fill that formula down beside column A Copy column B then paste...

@hollichh,

If you data is in column A, put the following formula in cell B1 (or whatever cell is next to your data:

= mod(row(b1))

Fill that formula down beside column A
Copy column B then paste special values back into column B to remove the formulas
Sort Columns A and B on Column B.

0 Replies

save every fifth cell in column to an other column

Related Topics

Quick Links

My Account

able2know