Tjyylli

Could you please stop shuffling the deck and play already?

Finding algorithms of QGIS commands?

What to do when during a meeting client people start to fight (even physically) with each others?

Is having access to past exams cheating and, if yes, could it be proven just by a good grade?

Do I really need to have a scientific explanation for my premise?

How could our ancestors have domesticated a solitary predator?

Make a transparent 448*448 image

How to pass a string to a command that expects a file?

Why is this plane circling around the Lucknow airport every day?

Should I take out a loan for a friend to invest on my behalf?

Word for a person who has no opinion about whether god exists

Could a cubesat be propelled to the moon?

Aliens englobed the Solar System: will we notice?

How to create a hard link to an inode (ext4)?

How do I express some one as a black person?

What is the meaning of triple curly braces {{{ }}} in phtml template files? When and how do we use them?

How are such low op-amp input currents possible?

My story is written in English, but is set in my home country. What language should I use for the dialogue?

Is Gradient Descent central to every optimizer?

Who deserves to be first and second author? PhD student who collected data, research associate who wrote the paper or supervisor?

Why the color red for the Republican Party

Peter's Strange Word

PTIJ: How can I halachically kill a vampire?

Can't find the Shader/UVs tab

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

Quickly increment selected numbers in Notepad++How do I generate a sequential number within an IF formula?Creating a pie-chart (of how many times a number is repeated) in ExcelExclude outliers from average calculationHow to fill down formula so that range references are offset by 5 rows rather than by 1 rowMatching and returning values to populate columnHow to generate random string from a set of available strings in Excel?Auto-fill a repeating pattern in ExcelHow do I filter a table in Excel based on a column of values?Easy way to extrapolate values in an excel tableFill a formula down without dragging in Excel for Mac 2011

5

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:

1

1

2

2

3

3

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 as 3.3, 3.7, 4.2, 4.8, etc.

microsoft-excel microsoft-excel-2007 worksheet-function

share|improve this question

edited Jun 5 '11 at 8:37

Lance Roberts

6,98684175

asked Sep 2 '10 at 15:05

PandincusPandincus

2342613

add a comment | 

5

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:

1

1

2

2

3

3

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 as 3.3, 3.7, 4.2, 4.8, etc.

microsoft-excel microsoft-excel-2007 worksheet-function

share|improve this question

edited Jun 5 '11 at 8:37

Lance Roberts

6,98684175

asked Sep 2 '10 at 15:05

PandincusPandincus

2342613

add a comment | 

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:

1

1

2

2

3

3

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 as 3.3, 3.7, 4.2, 4.8, etc.

microsoft-excel microsoft-excel-2007 worksheet-function

share|improve this question

edited Jun 5 '11 at 8:37

Lance Roberts

6,98684175

asked Sep 2 '10 at 15:05

PandincusPandincus

2342613

1

1

2

2

3

3

share|improve this question

edited Jun 5 '11 at 8:37

Lance Roberts

6,98684175

asked Sep 2 '10 at 15:05

PandincusPandincus

2342613

share|improve this question

edited Jun 5 '11 at 8:37

Lance Roberts

6,98684175

asked Sep 2 '10 at 15:05

PandincusPandincus

2342613

edited Jun 5 '11 at 8:37

Lance Roberts

6,98684175

edited Jun 5 '11 at 8:37

Lance Roberts

6,98684175

asked Sep 2 '10 at 15:05

PandincusPandincus

2342613

asked Sep 2 '10 at 15:05

PandincusPandincus

2342613

7 Answers
7

active

oldest

votes

13

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.

   A       B        C

1  1

2  1

3  =A1+1

4  =A2+1

5  =A3+1

etc.

share|improve this answer

answered Sep 2 '10 at 15:14

LunatikLunatik

3,282103762

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  For display purposes, no need to paste as values, right? This works just fine for me (in OpenOffice.org).
  
  – Arjan
  Sep 2 '10 at 15:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Arjan Absolutely.
  
  – Lunatik
  Sep 2 '10 at 15:34
  

  
  
  
  

add a comment | 

5

No Excel here, but in OpenOffice.org, filling down the following value and formula:

      A

1     1

2   =A1

...gets me new values and formulas:

      A

1     1

2   =A1

3     2

4   =A3

5     3

6   =A5

7     4

8   =A7

...which displays as you want it to.

share|improve this answer

answered Sep 2 '10 at 15:15

ArjanArjan

27k1065107

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I can't see how this works without using a + operator.
  
  – Tom Wijsman
  Sep 2 '10 at 15:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Tom, well, it surely does! :-)
  
  – Arjan
  Sep 2 '10 at 15:19
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Still... How does it know to count up? What if I want it to count down?
  
  – Tom Wijsman
  Sep 2 '10 at 15:21
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Works in Excel 2003. Can't tell you why @Tom, but it seems to. Not for counting down, however.
  
  – DMA57361
  Sep 2 '10 at 15:25
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Oh, I see. If you do this with a single cell it counts up, if you do it with two cells it counts up based on the second cell... Silly me. Argh, I can't upvote either unless the answer is edited... I should ask first next time.
  
  – Tom Wijsman
  Sep 2 '10 at 15:27
  
  
  

  
  
  
  

 | 
show 2 more comments

5

For a pure formula version,

=ROUNDUP(ROW(A1)/2,0) will fill down correctly. (If starting further down than row 1, subtract as needed.)

share|improve this answer

edited Jun 26 '18 at 6:42

phuclv

9,92164092

answered Sep 2 '10 at 19:35

Allen GouldAllen Gould

1513

add a comment | 

2

You could do the following. Bit heavy handed, but allows for you to do more advanced things in the if check to produce more obsure patterns.

After the first two manual entries it does not rely on you coping a "block" to get the repeated pattern. The if statement does if for you.

     A

1    1

2    1

3    =IF(A2==A1,A2+1,A2)

4    =IF(A3==A2,A3+1,A3)

etc

share|improve this answer

answered Sep 2 '10 at 15:27

DMA57361DMA57361

16.9k66195

add a comment | 

2

I find that entering formulas can cause problems later on if you need to sort, so I prefer not to use them for column filling. Instead, after a few minutes of trial and error, I came up with the following:

    A

1   1

2

3   2

4

Select the first 4 rows, and drag to fill. Now select the column, copy that, move to the second row, and do a paste special, selecting the add operation. Since empty cells are treated as zero, you will get the desired value after the source and destination cells are added.

share|improve this answer

answered Sep 2 '10 at 17:25

MBraedleyMBraedley

2,43732242

add a comment | 

1

Try this:

   a

1  1

2  1

3  =A1+1

4  =A2+1

Then select A3 and A4 (both should highlight with the marching ants border). Carefully move your mouse cursor over one of the bottom corners of the selection (like the bottom right corner) and drag it downward.

...what TomWij said... sorry, I was slow on the response =)

share|improve this answer

answered Sep 2 '10 at 15:26

MattMatt

39615

add a comment | 

0

see this pull square down

bout drove me crazy this is such a simple thing and I could not remember it. https://www.extendoffice.com/documents/excel/789-excel-create-and-insert-sequence-numbers.html this page where I stole the image. But links seam to go bad.

so select 1 2 3 then grab the bottom right square and excel Will FILL it in IT does know THese thigns are so easy to forget

share

edited 1 min ago

answered 7 mins ago

user30902user30902

1

New contributor

user30902 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f183882%2fin-excel-how-to-fill-down-consecutive-integers-following-a-pattern-1-1-2-2%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

13

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.

   A       B        C

1  1

2  1

3  =A1+1

4  =A2+1

5  =A3+1

etc.

share|improve this answer

answered Sep 2 '10 at 15:14

LunatikLunatik

3,282103762

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  For display purposes, no need to paste as values, right? This works just fine for me (in OpenOffice.org).
  
  – Arjan
  Sep 2 '10 at 15:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Arjan Absolutely.
  
  – Lunatik
  Sep 2 '10 at 15:34
  

  
  
  
  

add a comment | 

13

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.

   A       B        C

1  1

2  1

3  =A1+1

4  =A2+1

5  =A3+1

etc.

share|improve this answer

answered Sep 2 '10 at 15:14

LunatikLunatik

3,282103762

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  For display purposes, no need to paste as values, right? This works just fine for me (in OpenOffice.org).
  
  – Arjan
  Sep 2 '10 at 15:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Arjan Absolutely.
  
  – Lunatik
  Sep 2 '10 at 15:34
  

  
  
  
  

add a comment | 

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.

   A       B        C

1  1

2  1

3  =A1+1

4  =A2+1

5  =A3+1

etc.

share|improve this answer

answered Sep 2 '10 at 15:14

LunatikLunatik

3,282103762

   A       B        C

1  1

2  1

3  =A1+1

4  =A2+1

5  =A3+1

share|improve this answer

answered Sep 2 '10 at 15:14

LunatikLunatik

3,282103762

answered Sep 2 '10 at 15:14

LunatikLunatik

3,282103762

answered Sep 2 '10 at 15:14

LunatikLunatik

3,282103762

5

No Excel here, but in OpenOffice.org, filling down the following value and formula:

      A

1     1

2   =A1

...gets me new values and formulas:

      A

1     1

2   =A1

3     2

4   =A3

5     3

6   =A5

7     4

8   =A7

...which displays as you want it to.

share|improve this answer

answered Sep 2 '10 at 15:15

ArjanArjan

27k1065107

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I can't see how this works without using a + operator.
  
  – Tom Wijsman
  Sep 2 '10 at 15:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Tom, well, it surely does! :-)
  
  – Arjan
  Sep 2 '10 at 15:19
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Still... How does it know to count up? What if I want it to count down?
  
  – Tom Wijsman
  Sep 2 '10 at 15:21
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Works in Excel 2003. Can't tell you why @Tom, but it seems to. Not for counting down, however.
  
  – DMA57361
  Sep 2 '10 at 15:25
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Oh, I see. If you do this with a single cell it counts up, if you do it with two cells it counts up based on the second cell... Silly me. Argh, I can't upvote either unless the answer is edited... I should ask first next time.
  
  – Tom Wijsman
  Sep 2 '10 at 15:27
  
  
  

  
  
  
  

 | 
show 2 more comments

5

No Excel here, but in OpenOffice.org, filling down the following value and formula:

      A

1     1

2   =A1

...gets me new values and formulas:

      A

1     1

2   =A1

3     2

4   =A3

5     3

6   =A5

7     4

8   =A7

...which displays as you want it to.

share|improve this answer

answered Sep 2 '10 at 15:15

ArjanArjan

27k1065107

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I can't see how this works without using a + operator.
  
  – Tom Wijsman
  Sep 2 '10 at 15:17
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Tom, well, it surely does! :-)
  
  – Arjan
  Sep 2 '10 at 15:19
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Still... How does it know to count up? What if I want it to count down?
  
  – Tom Wijsman
  Sep 2 '10 at 15:21
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Works in Excel 2003. Can't tell you why @Tom, but it seems to. Not for counting down, however.
  
  – DMA57361
  Sep 2 '10 at 15:25
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Oh, I see. If you do this with a single cell it counts up, if you do it with two cells it counts up based on the second cell... Silly me. Argh, I can't upvote either unless the answer is edited... I should ask first next time.
  
  – Tom Wijsman
  Sep 2 '10 at 15:27
  
  
  

  
  
  
  

 | 
show 2 more comments

No Excel here, but in OpenOffice.org, filling down the following value and formula:

      A

1     1

2   =A1

...gets me new values and formulas:

      A

1     1

2   =A1

3     2

4   =A3

5     3

6   =A5

7     4

8   =A7

...which displays as you want it to.

share|improve this answer

answered Sep 2 '10 at 15:15

ArjanArjan

27k1065107

      A

1     1

2   =A1

      A

1     1

2   =A1

3     2

4   =A3

5     3

6   =A5

7     4

8   =A7

share|improve this answer

answered Sep 2 '10 at 15:15

ArjanArjan

27k1065107

answered Sep 2 '10 at 15:15

ArjanArjan

27k1065107

answered Sep 2 '10 at 15:15

ArjanArjan

27k1065107

5

For a pure formula version,

=ROUNDUP(ROW(A1)/2,0) will fill down correctly. (If starting further down than row 1, subtract as needed.)

share|improve this answer

edited Jun 26 '18 at 6:42

phuclv

9,92164092

answered Sep 2 '10 at 19:35

Allen GouldAllen Gould

1513

add a comment | 

5

For a pure formula version,

=ROUNDUP(ROW(A1)/2,0) will fill down correctly. (If starting further down than row 1, subtract as needed.)

share|improve this answer

edited Jun 26 '18 at 6:42

phuclv

9,92164092

answered Sep 2 '10 at 19:35

Allen GouldAllen Gould

1513

add a comment | 

For a pure formula version,

=ROUNDUP(ROW(A1)/2,0) will fill down correctly. (If starting further down than row 1, subtract as needed.)

share|improve this answer

edited Jun 26 '18 at 6:42

phuclv

9,92164092

answered Sep 2 '10 at 19:35

Allen GouldAllen Gould

1513

share|improve this answer

edited Jun 26 '18 at 6:42

phuclv

9,92164092

answered Sep 2 '10 at 19:35

Allen GouldAllen Gould

1513

edited Jun 26 '18 at 6:42

phuclv

9,92164092

edited Jun 26 '18 at 6:42

phuclv

9,92164092

answered Sep 2 '10 at 19:35

Allen GouldAllen Gould

1513

answered Sep 2 '10 at 19:35

Allen GouldAllen Gould

1513

2

You could do the following. Bit heavy handed, but allows for you to do more advanced things in the if check to produce more obsure patterns.

After the first two manual entries it does not rely on you coping a "block" to get the repeated pattern. The if statement does if for you.

     A

1    1

2    1

3    =IF(A2==A1,A2+1,A2)

4    =IF(A3==A2,A3+1,A3)

etc

share|improve this answer

answered Sep 2 '10 at 15:27

DMA57361DMA57361

16.9k66195

add a comment | 

2

You could do the following. Bit heavy handed, but allows for you to do more advanced things in the if check to produce more obsure patterns.

After the first two manual entries it does not rely on you coping a "block" to get the repeated pattern. The if statement does if for you.

     A

1    1

2    1

3    =IF(A2==A1,A2+1,A2)

4    =IF(A3==A2,A3+1,A3)

etc

share|improve this answer

answered Sep 2 '10 at 15:27

DMA57361DMA57361

16.9k66195

add a comment | 

You could do the following. Bit heavy handed, but allows for you to do more advanced things in the if check to produce more obsure patterns.

After the first two manual entries it does not rely on you coping a "block" to get the repeated pattern. The if statement does if for you.

     A

1    1

2    1

3    =IF(A2==A1,A2+1,A2)

4    =IF(A3==A2,A3+1,A3)

etc

share|improve this answer

answered Sep 2 '10 at 15:27

DMA57361DMA57361

16.9k66195

     A

1    1

2    1

3    =IF(A2==A1,A2+1,A2)

4    =IF(A3==A2,A3+1,A3)

etc

share|improve this answer

answered Sep 2 '10 at 15:27

DMA57361DMA57361

16.9k66195

answered Sep 2 '10 at 15:27

DMA57361DMA57361

16.9k66195

answered Sep 2 '10 at 15:27

DMA57361DMA57361

16.9k66195

2

I find that entering formulas can cause problems later on if you need to sort, so I prefer not to use them for column filling. Instead, after a few minutes of trial and error, I came up with the following:

    A

1   1

2

3   2

4

Select the first 4 rows, and drag to fill. Now select the column, copy that, move to the second row, and do a paste special, selecting the add operation. Since empty cells are treated as zero, you will get the desired value after the source and destination cells are added.

share|improve this answer

answered Sep 2 '10 at 17:25

MBraedleyMBraedley

2,43732242

add a comment | 

2

I find that entering formulas can cause problems later on if you need to sort, so I prefer not to use them for column filling. Instead, after a few minutes of trial and error, I came up with the following:

    A

1   1

2

3   2

4

Select the first 4 rows, and drag to fill. Now select the column, copy that, move to the second row, and do a paste special, selecting the add operation. Since empty cells are treated as zero, you will get the desired value after the source and destination cells are added.

share|improve this answer

answered Sep 2 '10 at 17:25

MBraedleyMBraedley

2,43732242

add a comment | 

I find that entering formulas can cause problems later on if you need to sort, so I prefer not to use them for column filling. Instead, after a few minutes of trial and error, I came up with the following:

    A

1   1

2

3   2

4

Select the first 4 rows, and drag to fill. Now select the column, copy that, move to the second row, and do a paste special, selecting the add operation. Since empty cells are treated as zero, you will get the desired value after the source and destination cells are added.

share|improve this answer

answered Sep 2 '10 at 17:25

MBraedleyMBraedley

2,43732242

    A

1   1

2

3   2

4

share|improve this answer

answered Sep 2 '10 at 17:25

MBraedleyMBraedley

2,43732242

answered Sep 2 '10 at 17:25

MBraedleyMBraedley

2,43732242

answered Sep 2 '10 at 17:25

MBraedleyMBraedley

2,43732242

1

Try this:

   a

1  1

2  1

3  =A1+1

4  =A2+1

Then select A3 and A4 (both should highlight with the marching ants border). Carefully move your mouse cursor over one of the bottom corners of the selection (like the bottom right corner) and drag it downward.

...what TomWij said... sorry, I was slow on the response =)

share|improve this answer

answered Sep 2 '10 at 15:26

MattMatt

39615

add a comment | 

1

Try this:

   a

1  1

2  1

3  =A1+1

4  =A2+1

Then select A3 and A4 (both should highlight with the marching ants border). Carefully move your mouse cursor over one of the bottom corners of the selection (like the bottom right corner) and drag it downward.

...what TomWij said... sorry, I was slow on the response =)

share|improve this answer

answered Sep 2 '10 at 15:26

MattMatt

39615

add a comment | 

Try this:

   a

1  1

2  1

3  =A1+1

4  =A2+1

Then select A3 and A4 (both should highlight with the marching ants border). Carefully move your mouse cursor over one of the bottom corners of the selection (like the bottom right corner) and drag it downward.

...what TomWij said... sorry, I was slow on the response =)

share|improve this answer

answered Sep 2 '10 at 15:26

MattMatt

39615

   a

1  1

2  1

3  =A1+1

4  =A2+1

share|improve this answer

answered Sep 2 '10 at 15:26

MattMatt

39615

answered Sep 2 '10 at 15:26

MattMatt

39615

answered Sep 2 '10 at 15:26

MattMatt

39615

0

see this pull square down

bout drove me crazy this is such a simple thing and I could not remember it. https://www.extendoffice.com/documents/excel/789-excel-create-and-insert-sequence-numbers.html this page where I stole the image. But links seam to go bad.

so select 1 2 3 then grab the bottom right square and excel Will FILL it in IT does know THese thigns are so easy to forget

share

edited 1 min ago

answered 7 mins ago

user30902user30902

1

New contributor

user30902 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

see this pull square down

bout drove me crazy this is such a simple thing and I could not remember it. https://www.extendoffice.com/documents/excel/789-excel-create-and-insert-sequence-numbers.html this page where I stole the image. But links seam to go bad.

so select 1 2 3 then grab the bottom right square and excel Will FILL it in IT does know THese thigns are so easy to forget

share

edited 1 min ago

answered 7 mins ago

user30902user30902

1

New contributor

user30902 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

see this pull square down

bout drove me crazy this is such a simple thing and I could not remember it. https://www.extendoffice.com/documents/excel/789-excel-create-and-insert-sequence-numbers.html this page where I stole the image. But links seam to go bad.

so select 1 2 3 then grab the bottom right square and excel Will FILL it in IT does know THese thigns are so easy to forget

share

edited 1 min ago

answered 7 mins ago

user30902user30902

1

New contributor

user30902 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

edited 1 min ago

answered 7 mins ago

user30902user30902

1

New contributor

user30902 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.