Help With Excel

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3151207%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EHelp%20With%20Excel%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3151207%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHello%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20fill%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E1%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E1%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E2%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E2%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E3%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E3%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ebut%20when%20I%20do%20the%20fill%20it%20comes%20out%20as%201%2C1%2C%202%2C2%2C%203%2C3%2C3%20This%20is%20just%20an%20example.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EIt%20is%20randomly%20either%20only%20putting%20in%20number%20once%20or%20putting%20number%20in%203x's%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EPlease%20help!%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3151207%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

Hello,

 

I am trying to fill 

 

1

1

2

2

3

3

but when I do the fill it comes out as 1,1, 2,2, 3,3,3 This is just an example.

It is randomly either only putting in number once or putting number in 3x's

Please help!

1 Reply

@NattiPie 

Perhaps

=INT( ( SEQUENCE(20)+1) / 2 )

will be enough