💻 Software

How to filter for every 4th row in Excel?

Fresh5 days ago

Mar 15, 20266820 views

Confidence Score0%

Problem

I have an Excel file (xlsx - MS Office 2010) that has a column (Just A) and 3000 rows. I want to filter for every 4th row. for example: and I want this result:

Error Output

TEMP -- 1
TEMP -- 2
TEMP -- 3
TEMP -- 4
TEMP -- 5
TEMP -- 6
TEMP -- 7
TEMP -- 8
TEMP -- 9
TEMP -- 10
TEMP -- 11
TEMP -- 12
TEMP -- 13

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: How to filter for every 4th row in Excel?

Low Risk

The easiest way is to use the function. The function prototype appears as follows: To apply this for your situation, set to the first cell of data (use an ABSOLUTE reference, see below in the formulas), to the offset, to 0 (since we don't want to sh…

Awaiting Verification

Be the first to verify this fix

How to filter for every 4th row in Excel?

Problem

Error Output

1 Fix

Fix for: How to filter for every 4th row in Excel?

Environment