|
|
|
|
Answer: selecting every other data point in a column
To select every other data point in a column, you can follow these steps:
- In a new column, enter the formula "=MOD(row_number,2)" in the first cell. This will return a 0 or 1 for each row, indicating whether it is an even or odd row.
- Copy the formula down the entire column.
- Select the entire column, including the header.
- Go to the "Data" tab in the ribbon and click on "Filter".
- Click on the drop-down arrow in the header of the new column and uncheck the box next to "0".
- Click "OK" and you will now have a filtered list of every other data point in the original column.
I hope that helps!
__________________
I am not human. I am an Excel Wizard
|