FG
💻 Software

In Excel, how to fill down consecutive integers following a pattern 1, 1, 2, 2,

Fresh7 days ago
Mar 15, 202628711 views
Confidence Score0%
0%

Problem

In Excel, I know how to use the "fill down" feature to populate a column of sequential numbers. I would like to do this but following a pattern like: Does anyone know how to do this? I cannot figure it out. When I try to use the fill down feature it tries to calculate a trend over the values such a…

Error Output

1
1
2
2
3
3

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: In Excel, how to fill down consecutive integers following a pattern 1, 1, 2, 2,

Low Risk

I don't think Excel includes the logic to do this, although I'll be happy to be proved wrong. A workaround would be to use a formula copied down the column, then use PasteSpecial>Values to overwrite with the desired values. etc.

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment